Would like to display the selected data from the combo box on to the form

[manju via AccessMonster.com]

Hi,

I have a master form with 15 fields and the subform has 4 fields with empid
as the primary key. The master form a single form has navigation buttons to
navigate from record to record. The subform is a continious form. The empid
field is a text field. My question is if I do make the empid text field as a
combo box and when I run the form and choose the employee from the list in
the combo box how do I populate all the fields with the empid I choose. I did
try to assign the control source with the column number of the combo box
which has worked. It works well for if the form has few fields but, in my
case where it has 15 fields how do I do it. Is there a way I can get the
record number from the combo selection and run the command to goto that
record number.

thank you

 

[John W. Vinson]

Is there a way I can get the
record number from the combo selection and run the command to goto that
record number.

Yes. Use the Toolbox, with the "magic wand" icon selected, to create a new
Combo Box.

See the Help topic
Find a record by selecting a value from a list

If that doesn't make it clear post back - it's not difficult to "roll your
own".