Where is acDataErrContinue?

[croby]

Hi, When I sent a message, I used the following coding in a control's Getfocus event:

MsgBox "Double-click this field to add an entry to the list."
Response = acDataErrContinue

The Access reponded with "Veriable not found" . I check the Action Constant listing. I coundn't find it either. Who knows where it is? Thanks. Chris

 

[Rich]

Are you sure it wasn't Response that Access was complaning about, did you
Dim Response As Integer ?

 

[Pat Hartman]

The GotFocus event does not include a Response argument. I have only seen the Response argument in the form's Error event. It is NOT a variable that you would define. Access would never know to look at one of your variables for this purpose.

 

[croby]

Thanks for all replies. I coded several events. I gave the event was not correct (sorry!). The code was in the NotInlist event. I copied it from a sample:

Private Sub cboResolve_NotInList(NewData As String, Response As Integer)
MsgBox "Double-click this field to add an entry to the list." Response = acDataErrContinue
End Sub

I guess it means: If data error, continue to proceed. I want to verify if my guessing was right, I even couldn't find where it is.
Is it in some component I did not install (Access 97)? Please help again. Chris

 

[Pat Hartman]

Once you get past A97, help is totally useless. I would recommend installing A97 simply to have the help files available.

Response is an argument of certain event procedures. Error and NotInList are 2. I don't know of any others offhand. I have found three values for response.

adDataErrContinue = continue processing without displaying the canned Access error message. Presumably, you have displayed your own error message or you don't want any message displayed at all.

adDataErrDisplay = continue processing but first display the canned Access error message. This makes sense as a default. You trap for certain errors and display your custom messages but any remaining errors need to be reported with the standard canned error message.

acDataErrAdded = This is the value you're supposed to set when your NotInList code added a new item to the combo.