SubForm record source

[MartinF]

Hi,

Please could anyone tell me how i go about altering the record source SQL statement of an open SubForm in VB?

I can do it for a normal form by using:

forms![FromName].recordSource = SQL statement

but i cannot seem to apply this to a SubFrom.

Any help would be greatly appreciated.

 

[Shep]

Forms!frmMainForm!ctlSub.Form.RecordSource = SQL statement

where...

frmMainForm is the name of the main form
ctlSub is the name of the subform control on the main form

Shep

 

[MartinF]

Cheers mate, thats just the job!