Filter does not update GoToRecord combo box

[jereece]

In the attached file, at the top of frm_Data, I have a combo box "GoToRecord" and a combo box "Filter". They both work fine except for one thing. When I apply a filter to show only Closed records for example, the GoToRecord combo box is not updated. It still shows all records and when I select a record I know is Open, it obviously can't go to that record because of the filter. How do I automatically update the GoToRecord combo box when a filter is selected?

As always, I appreciate the help.

Jim

 

[missinglinq]

I can't open your db; I'm running ACC2000 and you're apparently running a later version. My guess would be that after applying the filter you need to requery your other combobox.

GoToRecord.Requery

 

[jereece]

Thanks. I already had me.requery in the AfterUpdate Event but I added GoToRecord.Requery and that fixed the problem.

I don't suppose having 2 requery statements in one AfterUpdate event is a problem?

Jim

 

[missinglinq]

Me.requery only requeries the Record Source for your form, not the comboboxes on the form! Glad you got it fixed!

Linq ;0)>