Thank you Cheryl. The form works perfectly and your directions were very easy to follow.
Art
----- Cheryl Fischer wrote: -----
Access makes that fairly easy to do if you use the Command Button wizard to
add the button to your main form.
First, you will need to create the form that you want to display your
additional customer information. On that form, be sure to include the key
field (perhaps CustomerID) that will allow Access to find the exact info.
Then, on your main form use the Command Button wizard to drag a new command
button onto the form. Follow the prompts and, when you get to the prompt
that asks "Do you want the button to find specific information in the
form?", select the following option: "Open the form and find specific
information to display."
The next window will ask you to select/match the key field that Access will
use to find the correct information to match the information in your main
form. Select the matching field in each list box and click the button with
the "double-pointed arrow" <--> . Follow the rest of the prompts to finish
creating the button.
hth,
--
Cheryl Fischer
Law/Sys Associates
Houston, TX
Art said:
I am learning to use forms in Access 2000. I have a form I have created
from a query of customer information. I do not want to display all of the
information on what I will call the main form becuae I need to save room on
the form for a sub form. I want the remaining customerinformation available
in a pop up form when a command button is clicked on. Is there a way to
create a pop up form with the current record displayed in the main form as
the control source?
