Can anyone help me to fix my filtering using combo box in the frmBookingFilte r. The selection of combo box must come from tblRoom. Need to filter all the information in tblBooking based on tblRoom.Room.
i have 2 table
1) tblRoom (Room ID, Room, Building, Level, Ext)
2) tblBooking (Booking ID, BookingDate, Room, StartTime, EndTime, UserName, UserExt, Purpose, Chairman)
In the tblRoom, the number of room has been fixed. No addition of room in future (8 rooms). Thus, i would like to filter the records in tblBooking using the Room information.
I have created 2 forms, frmBookingEntry and frmBooking Filter.
p/s: i would like to attch my database, but i don't know how.
Thanks in advance
i have 2 table
1) tblRoom (Room ID, Room, Building, Level, Ext)
2) tblBooking (Booking ID, BookingDate, Room, StartTime, EndTime, UserName, UserExt, Purpose, Chairman)
In the tblRoom, the number of room has been fixed. No addition of room in future (8 rooms). Thus, i would like to filter the records in tblBooking using the Room information.
I have created 2 forms, frmBookingEntry and frmBooking Filter.
p/s: i would like to attch my database, but i don't know how.
Thanks in advance
Comment