Hi

I have two combo boxes on the same form that look up the values from the same field, same table. When I select a value in the first combo box, the second one automatically lists the same value! It's actually a travel database and it's not possible to depart from an airport and arrive at the same one - hence two combo boxes! How do I remedy this?! Thanks

Don't bind the combos to the table but leave them unbound.

Thanks for responding. However, I've tried this and it works for that particular record, but all following records change their data to say the same destinations! Aargh!!

Actually it sounds like they SHOULD be bound to fields underneath, probably lookup fields to a listing of airport codes.

Did you check the Properties sheet of your form? Tell us what it says under Data, Record Source, for each of these combos.