show records in query based off user input in form

[steallan]

Ok this might be basic stuff i'm a bit dumb

I have a query showing lots of records of equipment that is in different rooms. I would like to have a form where the user can bash in a room number and all the records from the query that have that room number in it pop up.

Please help the dumb

 

[Len Boorman]

If you are working straight from the query you could put in the query a parameter under the Room Number

[Please Enter Room Number]

When the query is run there will be a dialogue box appear asking for a Room Number

L

 

[steallan]

ace

that's not exactly what i was after but it will be really useful, thanks

found what i wanted in example database. just got to work out how to repeat it now.

thanks again

 

[Len Boorman]

Okay
If you have a form with a combo box containing the room numbers then your query can contain a parameter that refers to the combobox

[Forms]![Your Form Name]![Combo box name]

The on click property of the combo box has an event procedure

DoCmd.Openform "Your Display Form Name",acnormal,,,acReadonly
DoCmd.Maximise

Your display form has as its source the query containing the conmbo box parameter.

HTH

L