Subform Requery Trouble

[ztpkng]

I've tried the methods found online, but they are seemingly inconsistent for me.



I have a 2 tables: Screws and Selections (Screws is the main info for the database, and Selections holds the current "search" parameters and will only ever have 1 row).
I have a query: Filtered List

Filtered list has both Screws and Selections as source tables, but they aren't linked per se. Instead, I add a criterion for each field so that they must match, such as (for the TYPE field in screws): Like [Selections]![Type]. I did it this way so that a user could enter * and get all results if desired.

So, I have a form with subform. The form drives the single row of Selections. The subform returns a table of the filtered list.

The problem is that I can't seem to get the on event requery to work properly. When I added the query to the form, it created "Filtered List subform". The code I'm using is:

Private Sub Form_Current()
[Filtered List subform].Requery
End Sub

I've tried putting it on the Form On Current condition, on the enter and exit conditions for the option boxes where I'm setting values for the Selections table, etc, but no matter where I add the event, it doesn't seem to consistently update the table. Can someone suggest what might be going on or how to solve?

[June7]

Is that code in the Current event of main form? Is the main form bound?

Never seen the approach of another table for search criteria. The same can be accomplished without the second table by referencing unbound controls on form.

Review http://www.datapigtechnologies.com/f...tomfilter.html

[ztpkng]

Thanks for the tip! I like how clean that is, and for whatever reason it has fixed the other problem as well. Perhaps it wasn't pushing the info back into the table like I expected.