SubForm record source
SubForm record source
(OP)
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.
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.
RE: SubForm record source
where...
frmMainForm is the name of the main form
ctlSub is the name of the subform control on the main form
Shep
RE: SubForm record source