Listbox for a parameter query in a Report or Query

  • Thread starter Thread starter Tony DBA
  • Start date Start date
T

Tony DBA

Hi Everyone,

I have table set up that is called "Accounts Payable Check Listing"
which lists all the checks my company has paid out. I also have a query
that is named "AP checks" that is based off of the one table "Accounts
Payable Check Listing". In the query itself, I have one parameter query
setup that prompts you to enter in the Vendor Name.
If you type in the exact name of the vendor, the query will return
data.

I also have a Report that runs off of the Query mentioned above, and
whenever I run the report, just like query will....it prompts you for
the vendor name. The problem is.....if you don't know the vendor name
exactly as it is in the table....the query or report returns nothing
back.

My question: Is there a way to have a drop down list or LISTBOX in the
query or the report. I know you can do listboxes in Forms. But I've
tried all different ways to get this to work.

Ideally, I'd like for a user to double click or run this report, have
it prompt you for the "Vendor Name" field, once you select it in the
listbox...it will run the report and give you a list of checks for that
particular Vendor name you selected in the listbox prompt.

Is this possbile? Keep in mind....I am only a beginner in Visual
Basic.


Thanks for any help you can give me in this matter.

Tony
 
What I would normally do is to create a
Form "frmSelection" that has a ComboBox for the user to
select the Vendor and a CommandButton to open the Report.
You can use the reference to the ComboBox as the Parameter
in your Query.

When the user wants to run the Report, open "frmSelection"
first. He/she can select a Vendor then click the
CommandButton to run the Report.

HTH
Van T. Dinh
MVP (Access)


-----Original Message-----
Hi Everyone,

I have table set up that is called "Accounts Payable Check Listing"
which lists all the checks my company has paid out. I also have a query
that is named "AP checks" that is based off of the one table "Accounts
Payable Check Listing". In the query itself, I have one parameter query
setup that prompts you to enter in the Vendor Name.
If you type in the exact name of the vendor, the query will return
data.

I also have a Report that runs off of the Query mentioned above, and
whenever I run the report, just like query will....it prompts you for
the vendor name. The problem is.....if you don't know the vendor name
exactly as it is in the table....the query or report returns nothing
back.

My question: Is there a way to have a drop down list or LISTBOX in the
query or the report. I know you can do listboxes in Forms. But I've
tried all different ways to get this to work.

Ideally, I'd like for a user to double click or run this report, have
it prompt you for the "Vendor Name" field, once you select it in the
listbox...it will run the report and give you a list of checks for that
particular Vendor name you selected in the listbox prompt.

Is this possbile? Keep in mind....I am only a beginner in Visual
Basic.


Thanks for any help you can give me in this matter.

Tony



------------------------------------------------
Click to expand...
 
Back
Top