change source object on subform using VB

  • Thread starter Thread starter gymphil
  • Start date Start date
G

gymphil

Can anyone help!
I have a main form with a subform and am trying to change the subforms
source object using:
forms.mainform.subform.form.sourceobject = "new query name"
the results is a run-time error 2465
application-defined or object defined error
 
Use:
forms.mainform.subform.sourceobject = "new query name"

It is the subform control that has a SourceObject
The form in the subform control doesn't, so it can't figure out how to
assign it.
 
Just the job gentlemen, thanks very much for your assistance.
you were quite correct! I had to change the record source.

Cheers

Phil
 

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

tabs and subforms 1
Disable subform 3
Requery a subform on another form 4
Error when calling the On Load event of my subform 2
filter main form from a popup form 3
requery continuour subform 11
Procedure call to Main Form from subform fires once but not thereafter 2
Add Records From Subform to Table 2

Back
Top