I have a form to edit data, where there's three subforms on it. On one of the
subforms, there's three buttons for the user to choose from that opens
another form to be edited. (the user can only choose one, and these three
forms are only linked by this one subform)
I was just wondering if there were any examples of this anywhere on the web
that I can see how to do this the right way. Or does anyone know how I can
make this work?
Thanks

Hi short,

> On one of the subforms, there's three buttons for the user to choose from
> that opens
> another form to be edited. (the user can only choose one, and these three
> forms are only linked by this one subform)

Make the form that is opened from one of the buttons open in dialog mode.
The button that opens that form would have code something like this:

DoCmd.OpenForm "NameOfForm", , , , , acDialog

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"short" <short@discussions.microsoft.com> wrote in message
news:479D5C3E-BC2B-4B55-8799-D1A8E057B9D0@microsoft.com...
>I have a form to edit data, where there's three subforms on it. On one of
>the
> subforms, there's three buttons for the user to choose from that opens
> another form to be edited. (the user can only choose one, and these three
> forms are only linked by this one subform)
> I was just wondering if there were any examples of this anywhere on the
> web
> that I can see how to do this the right way. Or does anyone know how I can
> make this work?
> Thanks