Search results

I was trying to run it in a onclick() event. I was trying to add it to some simple VB code that I had found... 'DoCmd.SetWarnings False 'If Me.Status = "Active" Or Me.Status = "Inactive" Then 'Else 'MsgBox "Invalid Status" 'Cancel = True 'Status.SelStart = 0 'Status.SelLength =...

missinglinq- When I run that code, I get an error of "Compile Error: Variable Not Defined" on this portion of code: Cancel = True

I have VB Code running (which I pulled from another site), and I was wondering if there was anyway to make it say that ONLY these entries are valid. DoCmd.SetWarnings False If IsNull(DLookup("ProgramName", "tbl123", "ProgramName ='" & Me.ProgramName & "'")) Then DoCmd.RunSQL "INSERT INTO...