Lookup Wizard over Multiple Fields

[athyeh]

Hello All,



I am creating a form where a user inputs data into my main table. There will be two users inputting data using this form. One user identifies Operators by name, and the other user identifies Operators by Org ID.

In the form field "Operator" I am trying to create a lookup menu that allows the user to type/copy+paste/select EITHER name OR Org ID, but have so far been unsuccessful.

Through the lookup wizard I have managed to have the drop-down menu show both Name and Org ID (Looks like: John | 11351), and the user can input Name, but if the user just inputs Org ID, it returns an error that the message is not in the right format.

Can anybody help please and thank you.

[rpeare]

I don't think you can do it the way you want, however what you can do is capture the user by their windows login (assuming they log into your network) and use that to determine whether you show a combo box with the orgID or the user name.

Another option to consider would be to have an unbound 'search' field, the user puts in the string you're searching for and finds the appropriate record in your list of operators, just make sure you're always storing the PK of the table driving the combo box.

Here's an example:

http://www.opengatesw.net/ms-access-...pe-Access.html

[athyeh]

Thank you very much for your replies. This thread combined with input on another thread has been solved.