I have a form with a query attached that I cannot get the result to pull correctly. The code below is on a Combo Box:
SELECT Hotels.[ORS Prop Code], Hotels.[Property Name], Hotels.[General Manager], Hotels.City, Hotels.State, Hotels.[GM's Email Address], Hotels.[Phone #], Hotels.[Fax #], Hotels.[Operational Vice President], OVP_List.OVP_Email
FROM Hotels INNER JOIN OVP_List ON Hotels.[Operational Vice President] = OVP_List.OVP_Name;
The Combo Box is named Combo2. I have 2 text boxes: 1 with =Combo2.Column(8) which pulls the Operational Vice Presisent without any problem when an item is selected in the Combo. In the second text box, I have =Combo2.Column(9) which should be the OVP Email. The textbox just comes up blank, but when I run the query by itself, I get the correct information.
Any ideas what may be wrong?
SELECT Hotels.[ORS Prop Code], Hotels.[Property Name], Hotels.[General Manager], Hotels.City, Hotels.State, Hotels.[GM's Email Address], Hotels.[Phone #], Hotels.[Fax #], Hotels.[Operational Vice President], OVP_List.OVP_Email
FROM Hotels INNER JOIN OVP_List ON Hotels.[Operational Vice President] = OVP_List.OVP_Name;
The Combo Box is named Combo2. I have 2 text boxes: 1 with =Combo2.Column(8) which pulls the Operational Vice Presisent without any problem when an item is selected in the Combo. In the second text box, I have =Combo2.Column(9) which should be the OVP Email. The textbox just comes up blank, but when I run the query by itself, I get the correct information.
Any ideas what may be wrong?
