Subform Cmd Button

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sarah Stockton - 09 Mar 2005 16:51 GMT

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

Signature

Sarah Kathleen Stockton

Reply to this Message

Sarah Stockton - 09 Mar 2005 18:59 GMT

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

> 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
[quoted text clipped - 3 lines]
>
> thanks

Reply to this Message

Marshall Barton - 09 Mar 2005 19:26 GMT

>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.

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.

Signature

Marsh
MVP [MS Access]

Reply to this Message