New problem here and thanks again for all the help previously given. After making some tweaks to my tables, queries and other forms, I now have a new problem.
I have a form where I build rate quotes I get from hotels, Quote Input Form. It is a complex form for me as I pulls in information from tables surrounding bids, university information, and hotels. I have a feeling the issue may be in the record source, but I'm not sure.
When I retrieve a quote previously entered, no problem - everything pulls in beautifully. The issue is when I create a new quote from scratch. When I build a quote from scratch, I pull the bid info into the form via combo box. Then, from another combobox, I pull the hotel detail in. When I do, the hotel name shows up but none of the associated hotel data. If I save the new quote, it creates a duplicate hotel record with the hotel name only that was retrieved from the combobox.
Where is my issue? Thanks in advance for the response.
Matt