change subform recordsource

qwertyjjj

Registered User.
Local time
Yesterday, 19:57
Joined
Aug 8, 2006
Messages
262
I have a form with 5 tabs. Each tab has 2 subforms.
When the form loads I am trying to select it's recordsource by doing this:

Me!Subformname_A.RecordSource = "SELECT FieldA, FieldB FROM TableA WHERE"

However, it throws an error.
Is there something wrong with this ?
 
Me!Subformname_A.Form.RecordSource = "SELECT FieldA, FieldB FROM TableA WHERE"
 

Users who are viewing this thread

Back
Top Bottom