Message Boxes

[ptaylor-west]

I know how to create a MsgBox and enter it in events, but how do I stop the default system message from appearing.

At the moment my error message comes up but when I click OK the systems default message is there and I have to respond to that as well, which defeats the object.

 

[SteveA]

What are you attemtping to do when the system error is being prompted?

Access handles different errors in different ways.

SteveA

 

[ptaylor-west]

To stop people entering names and addresses into a Combo Box that are not on the main customer database I have set the properties as below:

Set the Limit to List box in properties of the Combo Box to Yes

Then on the NotInList box set an Event as follows:

Private Sub Company_Name_NotInList(NewData As String, Response As Integer)

MsgBox "You must add the Customers Name and Address to the Database first !"

End Sub

But the default message comes up after mine as well.

 

[Fornatian]

After the msgbox line add this:

Response = acDataErrContinue

 

[ptaylor-west]

Thank you Fornation that would have taken me forever to find.

Paul