M8KWR here I am with that question and file.

mws5872

New member
Local time
Today, 07:29
Joined
Jan 26, 2005
Messages
9
M8KWR here is the file I have converted it.
 

Attachments

Hello there

Ok what i have done is created you a preview button on the form.

this is linked ot the table1 report, hope this is ok.

You can see what i have done, if you view the record source of the report, and then you can copy that across to other report etc.

If there is anything else please let me know. Or drop me a private message at this site.
 

Attachments

looked at it

yeah it works great!!!! thank you soo much! but.... how did you do it :) thanks again.
 
its quite easy all i did was refer the report to your ID number which was "Complaint Number".

in the report if you go into the Record Source (which will look like a normal query) if you click on the 3 dots to the right of the line.

You will see under the "Complaint Number" i have typed

[forms]![table1]![Complaint Number]

To break this down for you [forms] is standard, this tells access you are referrring to a form. Then you put the form name you are referrring to, which was [table1], and then the field within the form [Complaint Number].

I would if a was you use a date filer for the report as well, so a person can preview/print all the complaints that was done on a particalur day.

I would also have something to say if the complaint has been dealt with or not, then you can run a report to display the complaint that are outstanding over a certain time period,l to make sure people are doing there jobs correctly.

There is so much you could do with this database. Give me a day and i could sort it out for you its quite simple.

This is a good way to do a report which you can let the user select what they want to see, so for example if you have a company and contact drop down, and report button, you could let the user pick a company, and preview the report just for that company. Or if they selected a company and contact, it would just display information about that contact for that company.

If you need any help, and you think i can help just drop me a private message and i will be glad to help, they is so much you can do
 

Users who are viewing this thread

Back
Top Bottom