Populating a field by selecting from a pop-up lookup list
Hi.
I've got a combo box "cmbxDepartmentID" whose row source is a lookup table "tblDepartmentLkup", which has over 3000 records, many of them similar in name (department names at a university / hospital). During data entry, the user will need to view all department options that are similar to the information on the written form (usually abbreviated).
What I have now is a button on the form that opens a parameter query "qryDepartmentLkup", where the user enters known info and wildcards (*). The user can then copy and paste their selection.
This works fine, but what I'd like to do is:
1. Have the button open a form (maybe "frmDepartmentLkup") based on the above parameter query, I guess in datasheet view.
2. Allow the user to select the desired option from the list, either by double-clicking the selection or single-clicking the selection, then clicking a button or performing a keyboard shortcut
3. Populate this value back into the origianal combo box "cmbxDepartmentID".
I'm thinking some sort of click event on the field in the pop-up form, which stores the value as a string variable, then maybe an event when the pop-up is closed, which puts that variable into the value property of the combo box.
Can someone please tell me if this is possible, and how to go about doing it? I'm faily new to programming and VBA, although I think I'm picking it up quickly. Is the type of thing I'm trying to do common?
Thanks!
