Pop up box for report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm a beginner for Access and I am trying to create an OpenReport command
that when someone clicks on a command button, a pop up box will open and ask
which report to open by product number. I only want one report/form to open
and I also would like to have the question pop up twice to limit errors.
Thanks so much!
 
I think you must create a form with a drop downlist of products and a button
the user selects the item
on click of the button obviously it depends on what you want to do.

if you want a different report (i,e, different structure per item) you must
do a select case to see which report to open.

if you want to do 1 report and open the item that user just selected, in the
query filter the item by referencing the dropdown list
 

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

Similar Threads

Enter Parameter Box pops up even though its not in query 7
Pass information from form to QUERY CRITERIA 6
Controlling another switchboard 2
Problem with parameters and a pop-up box 3
Pop-up Form 1
Variable Criterion for Query 2
Alternatives to Enter Parameter Value pop up box? --------- 3
Pop up box for data entry 7

Back
Top