Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2004

    Angry Unanswered: Help with DLookup Function, Justin

    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!
    Last edited by Justin04; 10-22-04 at 12:56.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts