Subform Filter

Jonno

Registered User.
Local time
Today, 22:32
Joined
Mar 17, 2003
Messages
74
I have a main form called F0, and a suform called F1. When I click a button I wish to apply a filter (saved as a query) to put the data in the Subform in a certain order. I am having trouble refering to the subform in code. What is the correct Syntax? It currently is unable to find the subform i am referring to. Do I need to set the focus within the subform before I apply filter?
 
One solution

Forms!F0!F1.recordsource = YourSQLString
Forms!F0!F1.requery
 

Users who are viewing this thread

Back
Top Bottom