dumb new guy with a question

[gkaste]

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.

 

[The_Doc_Man]

There is a form-based button wizard that will build a command button for you to do exactly what you asked on that form.

How it works is that it locates the key associated with the input value using the recordsetclone of your form's primary recordset. Then, if the search worked, it copies your recordsetclone bookmark to your primary recordset.

 

[gkaste]

Wizard...that sounds like it should be easy. I have a problem though. I have my menu form open in design mode, the wizard icon is selected, but when I make a button it wont open the wizard. How do I open it?


Edit.... I just showed how much of a newbie I am at this. I was clicking toggle button, not command button. I get the wizard now, let me go try what you posted.


And thank you for your reply!

 

[gkaste]

I have tried almost every option in the wizard, but all of them that do work just bring up the form or the report, and go to the first record, I cant get it to ask me what record to go to? Can you please help me a little more with what to do in the wizard?

Thanks again

Garrett.

 

[misslee1888]

Garret

Create a query with all the fileds in table which contains all the customer complain info. In the Criteria filed under your primary key insert the following

Like [Enter Complaint No]

This will prompt the user to enter in the number of the record they want. The Like is there so that if they do not know the number they would enter

*
and this would bring back all the records.

Save this query and the take a copy of your main complaints form. Now simply change the recordsource of this form from your table to your query.

Now when you open the form your users will be prompted to enter in a customer complains number and if so it will bring back this record. If not they enter * and all the records are brought back.

Now simply put a button on your main form opening the update form.

Hope this makes sense.

L.

 

[misslee1888]

This will work with the reports as well.

Create your report with all the nessessary fields and and make sure that the reports recordsource is the query that you have created.

This will prompt your user to enter in the complains no.

With the form.... If you make any changes to your update form this with antomatically change the table.

Let me know if you have any problems

L.

 

[gkaste]

Ah! Almost got it. Thanks so much for your reply. I had tried almost the same thing, but in the criteria I was trying the input and messagebox commands....how simple...just brackets.

It isnt working quite right yet, but I need to play around with it first. Boss has me elsewhere right now so I will have to try some stuff this weekend, but ya I think Ill need a little more help soon.

Thanks all
Garrett