VB Command to Update SubForm after Query SQL change

  • Thread starter Thread starter orbojeff
  • Start date Start date
O

orbojeff

I'm using a VB Command to change the SQL statement on my Query
qry_SEARCH
On the main form, frm_SEARCH, I have a sub form sfrm_SEARCH bound to
this Query


If I toggle between Design and From View the Sub Form will refresh
after the SQL change?
What command can I use to refresh this?


THanks
Jeff
 
Assuming the code is running in the main form??

then

me.MySubFormContorl.Requery

That should works....
 

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

Command to Close and Reopen Sub Form 1
VB Command to Update SubForm after Query SQL change 4
Coding help 0
Requery subform with new SQL 4
Prevent Full String Selection after Change Event on Control 1
subform based on external SQL won't requery 1
Refreshing a subform 2
Subform not refreshing 2

Back
Top