combo box dilemna

[russi]

Hi.

I have a form that has a combo box based upon a query (the rest of form is based upon a table).

There are 3 fields that show: Vendor, Contract Number, and Program Name.

The first column is the bound one (0).

I need to save each item in the client record that is the table the form is based upon.

I have the 3 separate fields on the form and code that says that each should equal the appropriate column in the combo box.

PROBLEM IS: only Vendor and Program Type save. The contract number does not. I use the same syntax. I account for the column number and, yes, I know the first one is '0'.

Any ideas?

Russ

 

[GTrice]

Yes, but why whould you want to store duplicative data? If you are populating the combo box from a table source then why not put a unique identifier on the source and store that number in you other table.

The first rule of data normalization is to eliminate duplicates.

(Hint: use a dlookup on an unbound text box to display the rest of the info on your form)