change the record source of subform runtime

  • Thread starter Thread starter 123
  • Start date Start date
1

123

thank you
is possible to change the record source of subform in runtime..
notes:
subform as data sheet in main form.
user can't make any design change because the protection
 
123 said:
is possible to change the record source of subform in runtime..
notes:
subform as data sheet in main form.
user can't make any design change because the protection
Click to expand...

Use this kind of syntax:

Forms!mainform.nameofsubformcontrol.Form.RecordSource = ...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subform record source tabbed page 2
Refresh calling form 7
Open form to proper record 6
Lookup current record with ComboBox, any changes create new record 3
subform total behaving strangely 2
Cannot set value via event 14
Multiple subforms 0
open subform no records 1

Back
Top