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