henryihunter1954
Registered User.
- Local time
- Today, 09:25
- Joined
- Mar 2, 2016
- Messages
- 89
I have a form that has a Drop-Down Menu.
After making the selection from the Drop-Down, I have a macro
that runs a query.
The query displays the fields that I need and also the field that has
the Value of the Drop-Down from the form. (The records that meet the
criteria should show in a report that is based on the query)
The problem arises when I get it to work properly, the next time I run
the macro, the query prompt shows up, asking me to input the value of
the Drop-Down menu.
I have already specified that I wanted the value to be the data in the drop-down but the prompt from the query comes up.
I need some suggestions as to how I can fix this problem.
I've done this many times before but not to go into a report.
I don't think that going to the report is really the issue.
Thanking you all in advance for suggestions.
After making the selection from the Drop-Down, I have a macro
that runs a query.
The query displays the fields that I need and also the field that has
the Value of the Drop-Down from the form. (The records that meet the
criteria should show in a report that is based on the query)
The problem arises when I get it to work properly, the next time I run
the macro, the query prompt shows up, asking me to input the value of
the Drop-Down menu.
I have already specified that I wanted the value to be the data in the drop-down but the prompt from the query comes up.
I need some suggestions as to how I can fix this problem.
I've done this many times before but not to go into a report.
I don't think that going to the report is really the issue.
Thanking you all in advance for suggestions.