open form

[magedalshaer]

hi
i have 2 forms , 1 have hotel information & other have cruise information, there is dropdown menu in a third form can allow me to choose either hotel name or cruise name
after i choose i would like to be able to click at the hotel or cruise name so i can have the form with the hotel or the cruise information


thanks allot
i am new pls. help me

[June7]

Hotel and cruise info are in different tables? How do we know which item in combobox dropdown is hotel and which is cruise? How did you build the RowSource for combobox?

[magedalshaer]

thanks your quick reply
Hotel in a table & cruise in another , I made the drop down menu using the union qry so I can have all the names , type could be known from the name , as Radisson blu hotel & Sonesta nile cruise , I would like to know the following
when I choose the name of cruise , system find the cruise form by name & get me the form with cruise information , When I choose hotel , system find the hotel & get me the form with the hotel information

if its possible we can open the 2 forms & check by iff statement , so keep the right match open & close the other

[June7]

Still, how does Access know that Radisson is a hotel and not a cruise? How does it know Sonesta is a cruise and not a hotel? Need a column in the combobox with this info.

SELECT ID AS CategoryID, HotelName AS EntityName, "hotel" AS Category FROM Hotels
UN ION SELECT ID, CruiseName, "cruise" FROM Cruises;

Then open appropriate form by referencing the combobox Category column index:

DoCmd.OpenForm Me.combobox.Column(2), , "ID=" & Me.combobox

This is just a simple example. I don't know your fields, tables, combobox, forms names.