change subform recordsource (1 Viewer)

qwertyjjj

Registered User.
Local time
Today, 11:58
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 ?
 

RuralGuy

AWF VIP
Local time
Today, 12:58
Joined
Jul 2, 2005
Messages
13,826
Me!Subformname_A.Form.RecordSource = "SELECT FieldA, FieldB FROM TableA WHERE"
 

Users who are viewing this thread

Top Bottom