Form creates a duplicate table record when saving

[TeamTraveler]

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

[TeamTraveler]

Never mind. I figured out my own problem. Thanks.

[June7]

Do you want to share? It might help someone else who encounters same issue.

[Missinglinq]

...another combobox, I pull the hotel detail in...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...

I suspect that the 'hotel' Combobox was Bound to the hotel name field in the underlying Table; for this purpose it needs to be Unbound.

Linq ;0)>

[TeamTraveler]

I suspect that the 'hotel' Combobox was Bound to the hotel name field in the underlying Table; for this purpose it needs to be Unbound.

Linq ;0)>

Bingo!! Things get a little clearer when you try to solve problem at the beginning of the day than at the end of it.

[Missinglinq]

Generally less hair left on the floor, as well!

Linq ;0)>