Parameters -- HELPPPPPPPP!!!! PLEASE!!!!!

  • Thread starter Thread starter Diana
  • Start date Start date
D

Diana

Hi,

I'm trying to open a recordset from a form that opens
another form and sets that form's subform's records to the
parameters on the first form.

It all works OK, but before the form w/the subform opens,
Access seems to requery the subform. I get a dialog box
that I have to cancel before I can see the recordset of
the subform.

Is there any way to fix this problem?

Thanks,
Diana
 
Diana

Not sure I follow the bread crumbs, but I'm wondering if you could delay
setting the 'source' for the subform until after something happened on the
main form (which may or may not be the first form in the list of forms you
described?!). An example might be if there's a combo box on the main form,
in that combo box's AfterUpdate event, you could set the subform's source,
dynamically.

Not sure if this applies...

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top