How to Start a pop up query from a botton in a form

[Norm]

I inherited an Access Database which contains client information table (
Contacts Table), for the people that come for Food. Our pantry is open every
Wed. morning and clients can come one time a month. Whenever a client comes
in they must be checked in and then the time and date are entered into the
Calls Table. When the client checks in I start the Contacts Form and and
search for the client's last name. When the proper record is found I click
on the Calls button at the bottom of the form. This brings up a window
displaying the results of a query on the Calls Table for this client. We
check to see if the cleint has been there that month if not the date and
time are entered, and the window is closed. We now have the need for another
Table (Family Table). This table contains the name age and relationship and
birthdate of every one in the house hold. I have created the table, query
and Form, now how to I add the botton to the Contacts form so that I can
access it as I do the Calls Table?

 

[Arvin Meyer [MVP]]

Add the new form as a subform. If you have enough room at the bottom of your
existing form, just you the toolbox subform tool with the wizard (magic
wand) turned on, and it will walk you through the links etc. If you don't
have enough room, you may have to add a tab control, then cut and paste your
Calls subform on the first page, and create the new subform (use the same
wizard) on the second page.