Help - populating a Listbox from a query with parameters?

[bensonince]

Hi,

I have created a query that is a simple select statement with one parameter. I would like to be able to populate my listbox with the information the query returns, How do i call the query (with a parameter).

I can set the rowsource to the query but this doesn't allow me to pass through a parameter.

HELP! please?

Cheers,

 

[Pat Hartman]

Use a form control to pass the parameter. Requery the listbox in the AfterUpdate event of the form field.

 

[beliado]

Pat is right on. In your query, change the parameter to [forms]![whatever_your_form_name_is]![text_box_name]... where text_box_name is where the user will enter the parameter. Then follow the steps he mentioned.