overriding errors

[purpledawn]

Hi everyone.

I have developed a form with a subform. Some controls on the subform are invisible and are populated from contols on the main form when they are updated.

Some controls on the subform must be populated before the subfrom can be updated, due to referential integrity rules. If the user clicks on the the subform before those subform controls are populated, an error is generated.

Does anyone have any ideas for interrupting the error, displaying my own error message, and shifting focus back to the main form?

Steve Veltman.

 

[THoey]

Look up error handling in help. Then, you can trap the error and display your own message. Terry M. Hoey

 

[Databaseguy]

Example:

Private Sub YourCommand Click()
On Error GoTo Err_Trap
'Code here
Err_Trap:
Select Case Err.number
Case 12345
Something
Case 12346
Something Else
End Select
End Sub

That's the general Ideer. Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[purpledawn]

Thanks for your help. Your suggestions led me to using the OnError event for the form. This allows me to set the Response value, which contols whether the default error message is shown. That makes it mucho easy! (See Error Event - Event Procedures in Help)