Question Locked

Microsoft Access

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to create a form with a drop down of hotels - and when a hotel is selected I need it to display information that is held in the same table but different columns as it pertains to that hotel such as address, phone, fax, rates and so on can anyone help I am completely lost in Access
Thanks

3 replies

by tony hopkinson

Drive your drop down from a a query like

select distinct hotel from hotels

Then your extra information will pick up the current selection and display the extra stuff.

by l j quick sr

I wish I had an answer, add me to your contact list so I can track this easier.
Thanks, LQ

This discussion is closed to new replies.