Query to prefill customer name on all reports?

T

Tara

I have a database that contains a list of vehicles, vin numbers, amounts
owed. Different employees save a copy of the Master database to their files
and use them for their customers/dealers. I need to find a way that I can
create something that non-access friendly users can prefill a form with their
customers name, address, city, & state and it will automatically update the
same field in each report ( I have about 8 reports). Right now, I have to log
onto each person's files, go into each individual report in design view, and
change each label.
 
T

tkelley via AccessMonster.com

You're on the right track with the form. Just build it so that the form
stays open (it doesn't have to be visible, but open). Then, in the report
fields in question:

=[Forms]![YourForm]![AppropriateField].Value

Then the report just looks in the form's field value to place into that field
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top