Sub Form Synchronizatioin

[Dalorax]

I have a main form w/ a table contain product name and batch number.
Each product is subjected to a different test for which i have created a seperate table. I have included individual pages (tabs) for the specific product. These individual tabs have the subforms based on the different test.
The main form has a unbound combo box to select product. I have code to enable / make visible the necessary sub form tabs. these subforms are linked by product name however when product is selected the subforms are not filtering properly.
I'm not sure if i have thouroughly explain the problem but i can clarify as necessary
Thanks for you all considerations

 

[Pat Hartman]

Filters don't work on subforms in some versions of Access. To "filter" a subform, you would have to replace its RecordSource with one that included the criteria in the SQL string.

Of course, if you can bind the main form, the subforms will be filtered automatically as long as their master/child links are properly set (boy there've been a rash of questions regarding un-sync'd subforms this week).

 

[Dalorax]

Thanks,

I was able to resolve the problem w/ a recordset clone in in the main form

e.g.

Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[ProductName] = '" & Me![cboProductName] & "'"
Me.Bookmark = rs.Bookmark