Changing Row source value in combo box to look up records

[bittorents]

Good morning all, I have a combo box in a form which is set up to look up by serial number:

SELECT [AppleVac_Inv_DB Query].[Serial #] FROM [AppleVac_Inv_DB Query];

Ideally, I'd like to look up by either a serial or a user name. The username field is "users" in the same query. How can I adjust the control source so that I can enter a user name and look up or enter a serial and look up? Is this possible?

Thanks all, this is by far and away the best source for help anywhere.

Thanks in advance!

 

[franklin97355]

Try the office forum68