I have a bunch of forms created which have an unbound combo box which is used to search the records.
On the "record source" for my "employees" form I have a query looking up all the fields in the table and the field "employeeID" with a critera Like [Forms]![Employees].[myselector] & "*"
The search works great when I open the form, if nothing is in the combo box all records show, once I select a record in the combo box it filters out the right record.
Now I'm trying to setup a "navigation system" and using the access 2010 navigation form, however once I add any form to it that has one of these combo box searches the form pops a dialog box when selected via the tab. If I click the combo box it still shows the record names however when I click a name a dialog box pops up and asks for me to input what it should figure out on its own. If I enter an employee ID it will retrieve the correct record
It seems like it can't locate the "myselector" combo box anymore to compare the ID now that's its in a subform on the navigation form. I tried changing the like statement to reference other areas of the database but can't come up with anything.
If anyone can help that would be great.
Thanks