pop-up listbox when report runs

[Darryl]

Greetings,
I have created a report. I want the user to select the city the report runs
for from a pop-up box that lists all the cities in the db. The pop-up box
would occur when the user runs the reports.

How do I get a pop-up list box populated with info from the db ?

thanks.

 

[Guest]

Darryl,

To populate a pop-up list (combo box) on a form do the following:

Create the form
Add the Combo box or List Box
Select the properties for the above
Select Row Source
Click the button to the right (...) This will load into Query mode
Add required table
Select the required field(s)
Close and save the query

If there is more than one column in the list to be displayed be sure to set
the ColumnCount property and dimension the Column Widths property by
separating each value (in cm) with a ";".

You will then have to reference the name of the object in the OnClick of a
push button control or in the AfterUpdate value of the list itself depending
on your choice of activation to run the report.

Darren