Hi all,
I'm trying to create 2 combo boxes that is used as a filter for a hotel inventory report. The first combo box is linked to a table with all our available destinations. I would like the 2nd combo box to show only hotels that are in the destination selected in the 1st combo box. I was thinking about creating a query based off the selecttion on the 1st combo box but I don't know how to do this. If anyone can help me with this I would really appreciate it.
Here are the 2 tables I have:
Destination_Table
Destination (FIELD)
Hotel_Name_Table
HotelName (FIELD)
Destination (FIELD)
Thanks in advance,
Tri
I'm trying to create 2 combo boxes that is used as a filter for a hotel inventory report. The first combo box is linked to a table with all our available destinations. I would like the 2nd combo box to show only hotels that are in the destination selected in the 1st combo box. I was thinking about creating a query based off the selecttion on the 1st combo box but I don't know how to do this. If anyone can help me with this I would really appreciate it.
Here are the 2 tables I have:
Destination_Table
Destination (FIELD)
Hotel_Name_Table
HotelName (FIELD)
Destination (FIELD)
Thanks in advance,
Tri