Pull up a report/form from a form based on id 1

[cdck]

I'm managing a customer club database for our giftshop, and am trying to simplify its use for our cashiers.

Currently, they have a form that they pull up to enter a new customer and record their contact information and interests. There is a separate form for recording purchases, which is linked in the tables to the contact information by customer id.

This allows me to keep only one entry for contact info per customer, but store a running listing of the pieces they've purchased in the club.

In order to see the pieces the customer has collected, the cashier has to remember the customer id, switch to the reports window, and then open a report using their number.

What I want is a way to add buttons to the original customer info form that will:

1. Pull up a data entry form for a purchase and fill in the customer id spot with their id.

2. Pull up a report of their collection based on their id.

I've floundered in the microsoft help files, and looked through the books on Access that I have, but I can't seem to find what I'm looking for - possibly because i'm not sure of the terminology I should be looking under.

How do I begin?

thanks,
Cheryl Kern

http://www.htowne.com

 

[KenReay]

Hi

There is a wizard which will do this for you, from the tool box, ensure the wizard is selected, then create a command button, follow the prompts from the wizard

the key is the syntax of DoCmd.OpenForm and DoCmd.OpenReport, see help for there two commands, particualrly the "Where" clause section

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[cdck]

Thanks, Ken.

Cheryl dc Kern

http://www.htowne.com