How to display results from a query in a drop down box/list box in a form

[helpme5]

Hi there,

I have a query (vehicleavailable) which uses parameters boxes so that the user can search for available vehicles for a certain date and time. However, I need to link this to a dropdown box / list box in a form so that when the user creates a booking, they can only select the vehicles that are available on the date and time that they input, using the original vehicleavailable query.

Any ideas on how I could do this?

Thanks.

 

[Dennisk]

set the record/row source of the combo box to your query

 

[helpme5]

I did that, but for some reason abnormal results appear at the bottom of each list/drop down box as shown below:

The 3 appears as vehicle ID with a 3 as registration, and this varies for each record and is not in the query. Any ideas on why it is doing this?
Thanks.

 

[Dennisk]

can't see anything. But the way to do this is to create a criteria form for all the users responses. Then alter the query so it refers to the values on the form.