filter using combo box quit working once form was put on navigation form

[robsworld78]

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

[WizardMonkey]

I'm having this exact same problem. Were you able to find the answer?

[robsworld78]

Yes and no, my solution was not to use the access navigation system and make my own dashboard. I made a form thats has no record source and added a bunch of pictures for buttons. You can do anything on the form just the same as the navigation system so I didn't spend much time trying to figure it out, I like mine better anyways. Sorry I'm not much of a help.