How do I use a list box to open a report based on a single record

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

Guest

I've created a form (as a menu) and on this form there is a button. When I
press this button it opens a list box. The list box is based on a query
which has selected customer id, first and last names from my database. I
also have a report which will provide me with specific details about each
customer.

I want to scroll down the list and click on the selected customer, and
automatically open the report showing that customer's details. I suspect I
need to create some macro or criteria in the query, but don't know how to do
this. Can anyone help me?
 
is the report bound to the query? and is CustomerID the primary key of the
table? if yes to both, there are two ways to get what you're after:

make sure that the CustomerID is the bound column of the listbox.

Solution 1
open the query in design view. in the CustomerID column, add the criteria

[Forms]![MyForm]![MyListbox]

substitute the correct names of form and listbox, of course. save and close
the query. in form design view, create a macro attached to the command
button, with an OpenReport action that opens the report.

Solution 2
in the form's design view, create a macro attached to the command button,
with an OpenReport action and setting the Where Condition, as

[CustomerID] = [Forms]![MyForm]![MyListbox]

substitute the correct field name, form name, and listbox name, of course.

hth
 
Back
Top