How to Capture SQL Error in VBA

[psb]

I have a form bound to a SQL table. The Primary key for the table is a combination of two columns; So if one column is not entered an SQL error pops up which is not reader friendly. I would like to capture this error in the front end (Access 2002) and display my own error message. Suggestions Please

 

[LaurieW]

I am trying to figure this out as well. I have scoured the forums here as well as Microsoft's Knowledge Base. I have tried various modules, etc. suggested by Microsoft but nothing works. I will be interested to see if you get any different advice...Laurie

 

[psb]

One way of doing it is to change the error description of the sysmessages table but I am hoping for a better way

 

[LaurieW]

I looked and I don't have a sysmessages table ... is this something you make up yourself or is it already supposed to be with the other default SQL tables?

 

[psb]

its a table in the Master database