How to keep a combo from changing the value of a field in a table.

[sljensen]

Im wanting to know how to stop a combo box from changing the value of the first record in the field every time I type in something different in the field. Or how do you get the value of the combo box to revert to nothing everytime you close the form instead of replacing the value of the first record. I'm new at this and I am not sure how to get this to work.

 

[boblarson]

Sounds like you have the form showing all records and when you open it, you should use something like this in the ON LOAD event:

If Not Me.NewRecord Then
   DoCmd.RunCommand acCmdRecordsAddNew
End If

So it moves to a new record right away instead of being on the first one in the form's recordset. You could also set all of the controls to locked until you want to edit them by clicking a button and unlocking them.

 

[vbaInet]

Sounds to me like you want the combo box to be unbound. If the combo box is bound to a field everytime you change the selection in the combo box it will get updated in the field it's bound to.

 

[sljensen]

Thanks un binding the Combo Box Worked

 

[vbaInet]

I'm not sure what you're after so boblarson may also be right.

To unbind a control you simply go to the Property Sheet of the control, click the Data tab and clear what's in the Control Source property.