fejl ved tilføjelse af data i komboboks

It is very likley because the table which you use in the combo needs other fields filling out.

If the table has fields which MUST contain data then it would be an idea to use form NOT IN LIST event to open a form where you can add the new record

Here is an example.

Also make sure that the Limit To List property is set to YES

Private Sub cboPostCode_NotInList(NewData As String, Response As Integer)
Dim strMsg As String
Dim sTown As Variant

    On Error GoTo Proc_Error
   
    strMsg = "PostNr findes ikke...."
   
    If MsgBox(strMsg, vbQuestion + vbYesNo, "findes ikke") = vbNo Then
        Response = acDataErrContinue
    Else
       
        DoCmd.OpenForm "frmPostCodes", , , , acFormAdd, acDialog, NewData
       
        'Check that record has been added
       
        sTown = DLookup("Town", "tblPostCodes", "PostCode = '" & NewData & "'")
       
        If IsNull(sTown) Then
            'record NOT created
            MsgBox "ikke tilføjet"
            Response = acDataErrContinue
        Else
       
            'Other controls are refreshed from frmPostCodes
           
            Response = acDataErrAdded
            Me.txtTown = sTown
           
        End If
   
    End If

Proc_exit:

    Exit Sub
   
Proc_Error:

    MsgBox "Der skete følgende fejl: ") & vbCrLf & err.Description, vbCritical
    Response = acDataErrContinue
    Resume Proc_exit

End Sub

stpa01ad>Is this question still relevant?
And I would also take a look at the other questions you still have open if you want help in future!

tak for hjælpen

jeg har accepteret svaret, så jeg håber du får point for det!

Jeg forsøger at acceptere dit svar, men der bliver ved med at stå at jeg ikke har accepteret det??

stpa01ad > Du skal markere terry's navn i boksen med afgivne svarere og derefter trykke på "Accepter".

I does seem to give problems, hopefully we'll get there in the end.

ok - tak for det mugs

:o)

thanks, to you also mugs!

Ren fornøjelse :o)

arent you out in your garden mugs? its a great evening!

Jeg er lige kommet ind efter en travl men dejlig dag. Har sat et par nye roser i krukker, repareret lidt på plænen, klippet nogle alt for store buske ned og checket mine krydderurter i drivhuset. Det ser ikke alt for godt ud. Min basilikum trænger til længerevarende varme. Men ellers alt vel.

:o)