Hi,

I need help with doing a simple search from a form that I have created. I have a couple of tables, a few queries, and a few forms. As you can guess, I'm quite new to MS Access. I would like to create a form that lets the user to enter a User ID number Then display the results in a subform.

Thanks,

masterskop

On a form, put a combo box that displays the User ID values that are available. This combo box will be "unbound" (its control source will be empty). On that same form, put a subform that displays the desired data for each User ID. In the LinkChildFields property of the subform control, put the name of the User ID field that is in the subform's query; in the LinkMasterFields property of the subform, put the name of the combo box that is on the main form. Now the subform and main form are linked.