On Sat, 5 Jul 2003 15:35:21 -0700, "Jen" <jen@noemail.com> wrote:
>I'm trying to select a record through a combo box and then
>based on that record I want to input information that will
>attach to that record on that table. Right now I select
>the number from a combo box, then I go to put info in and
>it puts it in the first record not the one I've selected.
If you have a "Bound" combo box, *that is precisely what it's intended
to do*. Check the Combo's Control Source property: if it's not blank,
then selecting a value from that combo box will overwrite that field
in the current record of your Table.

If, instead, you want the selection of a value from the Combo to find
a different record on the Form, you should be using an *unbound* combo
box with some VBA code in its AfterUpdate event to find the record.
The Combo Box wizard offers this as one of the options when creating a
new combo - "use this combo to find a record". If the wizard isn't
available, post back; the code isn't difficult.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]