[AccessD] Compile error

Kostas Konstantinidis kost36 at otenet.gr
Wed Jun 25 02:59:24 CDT 2003


Hi all,
I need some help please with an error message

when I try to enter a new record into... I get the follown error

Compile error
variable not defined

the code:
Private Sub idpoli_NotInList(NewData As String, Response As Integer)
    Dim strMsg As String
    strMsg = "'" & NewData & "' bla bla"
    strMsg = strMsg & "@bla bla;"
    strMsg = strMsg & "@bla bla."
    If MsgBox(strMsg, vbQuestion + vbYesNo, "new data") = vbNo Then
        Response = acDataErrContinue
    Else
        Set db = CurrentDb
        Set rs = db.OpenRecordset("T_poli", dbOpenDynaset)
        On Error Resume Next
        rs.AddNew
            rs!poli = NewData
        rs.Update
        
        If Err Then
            MsgBox "bla bla."
            Response = acDataErrContinue
        Else
            Response = acDataErrAdded
        End If
    End If

End Sub



Thank's a lot
Kostas Konstantinidis
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030625/75e171ca/attachment.html>


More information about the AccessD mailing list