Form Lookup Filter

[its_sam]

Travel database.
I want to set it up, so on a particular booking you select
a city. Then when you go to the next field, you have a
lookup on the hotels, but I only want to see the hotels in
the city chosen in the previous field.
How can I do this?
Thank you!

 

[Cheryl Fischer]

Here are a couple of KB links regarding synchronizing combo boxes:

How to Synchronize Two Combo Boxes on a Form
http://support.microsoft.com/default.aspx?scid=kb;EN-US;289670

ACC: How to Synchronize Two Combo Boxes on a Form (97624)
http://support.microsoft.com/default.aspx?scid=kb;[LN];97624



hth,