Combo Box posting to wrong record

  • Thread starter Thread starter Joel
  • Start date Start date
J

Joel

I have a simple form that has two (2) combo boxes. The first box is
tied to the main table and is used to find the required contract
number. The second box is tied to a different table which contains
status selections (i.e. complete, cancelled, ....). The first box will
display the correct record, and the second box displays all the
different status' correctly. However, upon saving the entries, the
information is posted to the wrong record. I don't understand where my
problem is since both combo boxes are pulling the correct information.
I would really appreciate some insight because I have obviously can't
see it.
 
I have a simple form that has two (2) combo boxes. The first box is
tied to the main table and is used to find the required contract
number. The second box is tied to a different table which contains
status selections (i.e. complete, cancelled, ....). The first box will
display the correct record, and the second box displays all the
different status' correctly. However, upon saving the entries, the
information is posted to the wrong record. I don't understand where my
problem is since both combo boxes are pulling the correct information.
I would really appreciate some insight because I have obviously can't
see it.
Click to expand...

A combo box used to *FIND* a record should be unbound - it should have
NOTHING in its control source. Otherwise, it will overwrite the bound
column with the value that you're searching for, in whatever record
was on the form when you started the search.

What's this combo's Control Source?

John W. Vinson[MVP]
 
Back
Top