Linking queries to forms

  • Thread starter Thread starter Amin
  • Start date Start date
A

Amin

So I have this query right now that uses a parametric input. What I would
like to do instead is have it use a scrollbar box on a Form. So instead of
typing in "Bill Stevenson", I can use this form to scroll down to Bill
Stevenson and this will result in a report opening.
 
You could use a combobox or a listbox on the form, and after selecting
his name in that box, you could run the report (either by clicking a
button, or directly on the After Update event of the combo/listbox).

your criteria for the report instead of a parameter would be something
like

forms![formname].[combobox]
 
Back
Top