Access SQL help

[JamesBowtell]

Hey all,

I have a Access form with a Variable that stores a Building Number

What i would like to do is list all the rooms that are in that building using the variable can anyone help?

i think the SQL would go somthing like this!

SELECT tbl_Room.Room_No, tbl_Room.Building_No
FROM tbl_Room;
WHERE tbl_Room.Building_No = Variable1

can anyone please solve this

Thanks

[Br1an_g]

try this:

"SELECT tbl_Room.Room_No, tbl_Room.Building_No" _
& " FROM tbl_Room " _
& " WHERE tbl_Room.Building_No = " & Variable1 & ";"

formatted the way i would use it within VBA

[JamesBowtell]

Thanks for the reply

I'm using the SQL editor for the Row Source property of a Combo box

I placed the SQL in the SQL editor, run the Program and when i click on the dropdown box i get this error message

'Datatype mismatch in criteria expression'

any idea?

[Br1an_g]

ah ok,

the previous statement is what you would use in a module.

to do this in the combo box source i would reference the form as you said the variable was on the form?

e.g.:

SELECT tbl_Room.Room_No, tbl_Room.Building_No
FROM tbl_Room;
WHERE tbl_Room.Building_No = [Forms]![YourForm]![YourTextBox]

[JamesBowtell]

Thanks worked great

cheers