Sorry, this is a very simple thing I need to do, but after hours of searching the net and this forum, and access help files I cant figure it out.
I have a simple database that keeps track of customer complaints. I have one form, it lets the user input all the information, which is saved into one table. Each customer complaint has a unique number assigned to it, which I use at my primary key, and also autonumbers, so each time a new report is made the new cust. complaint number is made.
I also have a report, which looks the same as the form, except no background color, formatted for printing better.
I also have another form that is a menu which has 4 buttons: new cust complaint, view cust complaint (will print from this one), edit cust complaint, and view log(which exports the table to an excel file)
On view cust complaint I want to click a button, then it prompt for the cust complaint number the user wants to get, then to load just that into the report. On edit cust complaint I want the same thing but load to the form.
Can anyone at least point me in the right directions? I have been trying mostly with queries, but cant get it to work. Any help would be apperciated.
Thanks
Garrett.
I have a simple database that keeps track of customer complaints. I have one form, it lets the user input all the information, which is saved into one table. Each customer complaint has a unique number assigned to it, which I use at my primary key, and also autonumbers, so each time a new report is made the new cust. complaint number is made.
I also have a report, which looks the same as the form, except no background color, formatted for printing better.
I also have another form that is a menu which has 4 buttons: new cust complaint, view cust complaint (will print from this one), edit cust complaint, and view log(which exports the table to an excel file)
On view cust complaint I want to click a button, then it prompt for the cust complaint number the user wants to get, then to load just that into the report. On edit cust complaint I want the same thing but load to the form.
Can anyone at least point me in the right directions? I have been trying mostly with queries, but cant get it to work. Any help would be apperciated.
Thanks
Garrett.