Filtering a sub form

[jbfraleigh]

I have a subform on my main form. Note that there is no relationship between the recordset of the main form and the recordset of the subform.

I need to be able to change the filter on the subform dynamically during run-time. I know this sounds a little odd because in theory I should be able to drive the subform off the main form using the LinkChildFields / LinkMasterFields.

Anyway, some things that I've tried:

Forms![MainForm]![SubForm].Filter = Blah
Forms![SubForm].Filter = Blah

Any help would be appreciated!

Thanks

 

[KenHigg]

forms!MyFormName!MysubFormName.form.fiter

 

[jbfraleigh]

Thanks, Ken! It figures that I was missing something obvious!!