How Do I Make Access Use User-Entered Customer Number for Parameter

[italianfinancier]

I built a database and the user enters a customer number and a report generates for that customer. The issue I have is that after the user enters the customer number, Access displays a parameter request for the text box on the Form the user enters the customer number in/on. (Please see pictures attached.) How do I get it setup so that the user doesn't have to enter the customer number twice? In other words, so that the parameter dialog box doesn't appear?

[alansidman]

What is the code behind the command button?
What is the SQL statement for the query? Or is it part of your VBA code for the command button?
Need to see these to diagnose what is really happening. Not enough information provided here.

Alan

[italianfinancier]

Attached is the macro behind my button (top half of Word document) and an example of one "programming" of the queries running to populate this report.

Thanks!

[ketbdnetbp]

If your report is based on the query at the bottom of the word doc you posted, try deleting the where condition (=[Text4]) in the macro. I don't think you need it because the query for the report has the criteria already established.

All the best,

Jim

[italianfinancier]

That made nothing happen when I clicked the button...no query run, no report generation, etc.

[ketbdnetbp]

Can you please post the entire macro, as it is now, that runs when the button is clicked?

Thanks,

Jim

[alansidman]

I don't use macros in any of my db--only VBA. If you want to convert your macro to VBA, use the convert function on the ribbon. I would then be happy to help diagnose the issue.

BTW; did you use the wizard when you created the command button?

Alan