Combo box gone wild

[Guest]

I fixed a combo box to access the correct table of information (Accounts
payable code for Purchase orders). But now every time that I fill-out the
form to generate a new PO this combo box resets the account number for ALL
PO's. How can I make the entry for each PO permanent without changing all of
the others?

Help ...

 

[fredg]

I fixed a combo box to access the correct table of information (Accounts
payable code for Purchase orders). But now every time that I fill-out the
form to generate a new PO this combo box resets the account number for ALL
PO's. How can I make the entry for each PO permanent without changing all of
the others?

Help ...

The combo box control source must be bound to a field in the table
(just like a regular text control).

 

[David C. Holley]

Sounds like there's a problem with the ControlSource for the comboBox
and/or the BoundColumn. Check that the ControlSource is set to the
correct field. Also check that the BoundColumn for the comboBox is set
to the Column in the comboBox's record source that represents the value
that should be stored. I personally always set up the recordsource where
the column for the BoundColumn is always first so that I don't get
confused as to which column contains the value to capture.