Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SubForm record source

Status
Not open for further replies.
MartinF

MartinF

Technical User
Sep 19, 2000
143
FR
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.
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
938
Kennelbloke
Kennelbloke
Bubba002
  • Locked
  • Question
Pass a subform fieldname-ID as a string variable in CF expression
2 3
Replies
50
Views
3K
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Use Crosstab query in subform
Replies
9
Views
708
dhookom
dhookom
TrekBiker
  • Locked
  • Question
Subform not updating 1
Replies
12
Views
922
TrekBiker
TrekBiker
TrekBiker
  • Locked
  • Question
This is the source query for what 1
Replies
12
Views
597
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top