Requerying controls on subforms question

  • Thread starter Pamela via AccessMonster.com
  • Start date
P

Pamela via AccessMonster.com

Hello;

I know how to requery controls on subforms, but what about this one? I can't
seem to figure it out:

I have a form with subforms on it. One of these subforms contains a control
button which, when clicked, opens another form with a subform. The subform
on the first form & the form opened by the button are based on the same table
(tblTaskAudit). The only problem I'm having is getting the record id to
propagate to the form opened by the button. If I move through the records &
go back the record id is there, but I'd like for the record ID to display
when I first open the form.

Thanks.
-Pamela
 
C

Chris

Call DoCmd.OpenForm "formName", , , "([ID]='" & whatever your ID field is &
"')"

HTH

Chris
 
Top