Pop up with Combo box for parameter report

  • Thread starter Thread starter Roy Challen
  • Start date Start date
R

Roy Challen

Thanks to all in advance - you have been so helpful in the
past.

Please could someone explain the process I need to be able
to CHOOSE a value from a Pop Up Form Combo Box that will
set the parameter value and open a report.

Thankx Roy
 
Add a ComboBox and CommandButton to your form.
Set the source query for your report to use the ComboBox
Click to expand...
as the criteria for the appropriate field. (The syntax
is: [Forms]![FormName]![ComboBoxName])
Set the CommandButton to make sure an item has been
Click to expand...
selected in the ComboBox (use code or a conditional
macro). If one has, run the report. If not, kick out an
error message to the user.

Hope this helps!

Howard Brody
 
Back
Top