findfirst

[Ann]

I have a form with 6 fields on it, some text boxes and some combo boxes. The
first box is a combo box of names. The second box is the person's ID number.
I have set up a findfirst method so that when you select a name from the
first box, the id for that person shows in the second box (if that person is
in the list). The rest of the boxes on the form are more info on that person.
I want those fields to fill in as well as the ID field when I select the name
from the first box. I can't seem to figure out the code. I keep getting the
id number in all the fields after I select the name. I have Access 2003.

Thanks.

 

[Ken Snell \(MVP\)]

FindFirst most likely isn't the method to use. Easiest way to do what you
seek, though, is to use the combo box with names in it as the source of all
the other fields. See this article for more info:

http://www.mvps.org/access/forms/frm0058.htm

 

[Ann]

That worked. Thanks for your help.

FindFirst most likely isn't the method to use. Easiest way to do what you
seek, though, is to use the combo box with names in it as the source of all
the other fields. See this article for more info:

http://www.mvps.org/access/forms/frm0058.htm