Combobox to search for existing record (1 Viewer)

[sbuckingham25]

I am creating a menu that has the option to search for an existing job, then opens a form that has a combobox. When the user selects the job, that form and record pops up.

Would this be run by a query?

 

[weilerdo]

yes you could set it so that once they make a selection in the combo box it opens a new form based on a query that uses the combo value as the criteria in your query. So if the combo returns work_id number then your query would have something will

SELECT blae blae blae
FROM blae blae blae
WHERE (work_id = FORMS!YourFormName!Combobox)