refer to a subform in VBS (A2000)

Topic

New Reply

I want to set the Record Source property on a subform, but I haven’t figured out how to refer to the subform. I’m setting the Record Source on the main form with this code: Me.RecordSource = “qryaudit0000k1” but how do I refer to the subform?

Reply | Quote

Replies

Gary,
Use :
Me.NameOfSubForm.From.RecordSource = “NameOfSource”

Reply | Quote

When I use this, Me.auditsf.Form.RecordSource = “qryauditdetail0000K1” I get this error, Compile error: Method or data member not found. I still need further enlightenment.

Reply | Quote

Gary,
Are you sure that ‘auditsf’ is the name of the subform control ?
In the properties of the subform, tab Others, Name ?
If you use the name that you find in the database windows and the name of the subform control is different, you get an compile error.

Reply | Quote