For example, create your form, and then use the combo box wizard to look up the user field in the table you are basing the query on. This should take the PK for the User, like UserID.
Then in the query based on the look up for, in the criteria line for the UserID field, for example, do this:
[Forms]![frmMyUserForm].[cboUserCombo]
When the query opens it will take the value from the combo box with the user look up by itself.
Did this help?
mmcdonal
|