Combo box search problem

[scooteman]

Hello

I have a training records form/subform with a combo box that I created with the wizard to look up and go to specific records. The combo box works fine when I open the form directly. The problem I am having is when I open the form from my "Employees" form using a wizard created button to go to a specific record. When I open the form that way my combo box control no longer works. I know it has to do with the fact the form is opened up with the filter showing only one record.

How do I get my combo box to work? The wizard built a macro under the after update property. I tried to the requery method but couldn't get it to work.

Thanks

 

[John Big Booty]

To get the combo to work you will need to set the form's FilterOn property to False, this will remove the filter from the form.

 

[John Big Booty]

You could do this using a hidden button that becomes visible when the filter is on. You may also need to requery the form so that all records are available.

 

[scooteman]

John,

Thanks for the input. I did find another way to fix my problem. I changed the macro on my "Employees" form and took the Where Condition out of the OpenForm action and inserted a SearchForRecord action after the OpenForm action and added my where condition there. Now my Training form opens up with all records but goes to the specific record I am looking for from the "Employees" Form.

Thanks for your help, it started me to look in the right direction.