Subform Cmd Button

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

Guest

I have two forms that have a one to one relation. I want my user to fill out
the first form and then if they need the second form they press a command
button and it opens the second form. I can't figure out the code for Access
to treat the second form as if it were a subform. I want it to know that the
subform belongs to the first form.

thanks
 
I have come closer to knowing what it is that I want. I want a TogleLink for
my users to click so that they can access the other form.

sks
 
Sarah said:
I have two forms that have a one to one relation. I want my user to fill out
the first form and then if they need the second form they press a command
button and it opens the second form. I can't figure out the code for Access
to treat the second form as if it were a subform. I want it to know that the
subform belongs to the first form.
Click to expand...


If you want a true subform control to display the second set
of data, then place a subform control in the main form and
toggle its visibility. You would probably use the
LinkMaster/Child properties to coordinate the two sets of
data, alternatinvely, you might prefer to set its
RecordSource property.

If you want the second set of data to be displayed in a
separate form, then you can use the OpenForm method's
WhereCondition argument to filter the second form's data to
the matching record.
 
Back
Top