Can anyone tell me how to do this? I have a form called Reservations. There is a label called Category and a combobox that displays Economy, Suite,and Deluxe. There is also another field which is called Amount and RoomNo. The Category is located in a table called tblRoom and the RoomNO is in that table as well. The Amount field is located in a table called tblRoomDes. What i am trying to do is when i select the Category and choose one of the three the values for the Amount will change and so will the Room. FOr example if i choose Economy then the amount would be 120 and for the Room no it would list only those that are economy rooms. Get the point? I have used a Combo box for the Category and for the Amount I should use the DLookup Function. But for the RoomNo and the Amount i must also use some Vba code. Can any one please help me out!