Subform - Update after Main Form updated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a subform linked to the Main Form by ID. I have the Main Form set to
open to a new record. I do not want the query for the subform to run
automatically - I'd like to click a button to run it only when needed as it
takes a minute to run. Most often the Main Form is used to update a Table,
and the subform is not needed. Right now it is running when the Main Form is
opened. How can I avoid this? Thanks!
 
Does it have to be a subform? I would just add a cmd button
and on click to open your other form as a form not as subform.

Armin_a
 
set the source object of the subform to the empty string

for instanc
for instance, if the subform control is called sf1 and you want to turn off
or turn on display of the form "frm_test", this code will toggle its
display:

Me.sf1.SourceObject = IIf(Me.sf1.SourceObject = "", "frm_test", "")

good luck
 
Back
Top