Saving bound and unbound fields

[mejia.j88]

i have a form where, after choosing the part number, two other text boxes get filled with information about that part number. These two other text boxes are unbound fields, and when i click the save button on the form; all of the info entered gets saved in one record, and creates a new record for only those two unbound boxes.



This means all of my information on that form is saved on two separate consecutive records.

any help on what i think is a simple question that i cant answer?

[June7]

First of all, why are you saving the info from the unbound textboxes? This sounds like duplication of data. Isn't that data already stored in a parts info table and can always by retrieved in query that joins parts table to the other table?

Show the code for procedure that is saving the data. Think I know what is happening but show code so can analyse.

[boblarson]

I second June7's answer. You should NOT be storing this data again if it is already in the original table which the combo box is based on. All you should be storing it the PartNo or the PK of the record (if different).