Error Handling on ODBC Linked Tables (odbc error)

[sisieko]

My tables are sybase linked tables to my Access front end. I get this error whenever i click away from my mainform while my not-null fields (textboxes) have not been entered. So, i would like to put an error message "somewhere" that tells the user to fill in the necessary fields and highlight the necessary textboxes in red, instead of this scary ODBC message

http://img82.imageshack.us/img82/6829/error0el.png

When i put my error handling in the afterUpdate or afterInsert Event. I still get the above error msg instead of my msgbox.
Where do i put this message? or should be question be, "what the proper way to handle this intimidating error?

Here's my error handling:

On Error GoTo Err_Form_AfterInsert
  
  'do something

    
Exit_Form_AfterInsert:
    Exit Sub

Err_Form_AfterInsert:
    MsgBox Err.Description, vbExclamation, "Please enter the Project Name, Project Leader Initials, Main User and Status Code" & Err.Number
    Me!Combo67.BackColor = "red"
    Me!Combo65.BackColor = "red"
    Me![Project Name].BackColor = "red"
    Me![Project Leader Initials Combo].BackColor = "red"
    Resume Exit_Form_AfterInsert

Thanks in advance for your help

 

[BuilderSpec]

You could try the Form_BeforeInsert or Form_BeforeUpdate. You may have to manually check each field to be non-blank then shove out your own message if any are blank.

 

[sisieko]

Thanks BuilderSpec...I just tried that. Still no luck

 

[snyperx3]

How about the LostFocus event of the textbox?


-Pete

 

[BuilderSpec]

Hi

Try using the cancel property on the Form_BeforeUpdate routine.

Do some checking to see if the fields have correct values etc, if they don't then say

Cancel = -1

this will prevent the data being updated with invalid values...you can shove out your own message at this point. All this will occur before the ODBC stuff has a chance to ruin it with it's horrible message.

Regards

BuilderSpec