Opening a New Form from a Subform

[Shea Brown]

Hello...

I am creating a database to track "clients" for a Food Pantry Charity and
I'm pretty new to Access. I have two tables that are linked by a Client Id.
I have a Main form with a couple of buttons for searching and Creating a new
Client. I also have a subform that is basically a table of all the clients
in the database. I also have forms for individual client information and
client visits.

I want to be able to open the form (appropriately named "Client Form") for a
client that is double clicked on in the subform of the main form. Right now
I can only scroll through those and search through those.

How should I go about doing this?
Thanks,

Shea

 

[Wayne-I-M]

Hi Shea

I may be wrong but I think you may have your forms the wrong way round.

I have a Main form with a couple of buttons for searching and Creating a new
Client. I also have a subform that is basically a table of all the clients
in the database. I also have forms for individual client information and
client visits.

Your main form should be the "main". By this I mean that that you would use
the main form to serach, add, etc new clients and the subform should be based
on the child field of the main - this is specific information regartding the
client selected in the main. - Hope this makes sense.

I want to be able to open the form (appropriately named "Client Form") for a
client that is double clicked on in the subform of the main form. Right now
I can only scroll through those and search through those.

You should select the cleint in the mainform not the sub.

So open the form that you now use as the sub form and reagred the fields to
make it how you want and then insert a subform (this will be the form that
you are at the moment using as your main). In the data column linkt the
child and master fields.

See how it works and if you have a problem - send another post in

Hope this helps