Locking a Combo Box

[Troubled1]

Hello Everyone,

I'm having some problems with a form that I built for a database. I'm using this database for inventory. I have a combo box that contains the serial numbers of equipment. There are text boxes that populate when the serial number is selected.(Model Number, Description, etc...) My problem is when I close the database, the serial number in the table changes. I have tried locking the combo box, but then I can't change the serial number at all. I have set the field on the table to no duplicates; that works but, I have to go to the first record to close the database without those annoying error messages. Thanks in advance for any assistance.

 

[jimb0ne]

so you have a combobox which is bound to a serial number field in your table. How are you populating the other boxes on your form when you select a new serial number? What do you mean by "the serial number is changing" when you close the form? If I am viewing a record that has serial number 10, and close the form, the record that used to have 10 will be something different? Is this the case? I could help more with a little mor einformation.

 

[Troubled1]

Thank You JimbOne,

What you said about the combo box being bound solved my problem. I unbound it from the table, and it works great. What was happening with the box was that when I selected the serial number and closed the database, it would duplicate that serial number in the table to the wrong record.