blank combobox vil ikke gemmes på SQL

How are you tying to save the record, in code or through the bound form?

Well the combobox is bounded to a table and I have a save button on the record, but I also have some vb code on the form - so a msgbox will pop-up and ask the user if the changed data or new data should be saved or not.

The combobox is bound to a table where it gets its data from, but is the data on the form bound to a table so that when you change dat it gets written to the dB automatically (BOUND FORM). I would think it is.
Normally the value from the combo which gets written to the table will be the primary key field which normally is a long integer (number). Make sur ethat the field in the SQL server table is also a number on not text.

well i have some primary keys as nvarcher but it same on both tabels.

its going to be difficult to find the problem without seeing the dB and as its using an SQL server that wont be easy.

If you havent made any changes to the Access dB other than move the tables to an SQL server. And as long as the data types are the same, tehn I dont see why it shouldnt work.

@terry
yeah its only with comboboxes it fucks it up.

Til dem der måske har den samme problem og får den samme fejl meddelelse op så har jeg pt. gjort det her istedet for:

I forms har jeg valgt before update event og indsat denne kode:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim strMsg As String
    'Nyt
      If IsNull(Me.Type) Then
      Cancel = True
      strMsg = strMsg & "Du mangler at udfylde: Type." & vbCrLf
  End If
 
  If IsNull(Me.RumNr) Then
      Cancel = True
      strMsg = strMsg & "Du mangler at udfylde: RumNr." & vbCrLf
  End If
 
'etc.

If Cancel Then
      strMsg = strMsg & vbCrLf & "Udfyld formularen eller tryk på <Esc> for at fortryde."
      MsgBox strMsg, vbExclamation, "Invalid data"

End Sub

På den måde tvinger man brugeren til at udfylde comboboxsene før det kan gemmes og så undgår man fejlmeddelelsen. Men jeg ville nu gerne finde ud af hvorfor jeg ikke kan beholde comboboxne blanke på SQL serveren???? :(