Form View Error Handling (2003)

Topic

New Reply

I have a field, Bag Number, where Indexed is set to Yes(No Duplicates). When entering data in table view an error is generated if a duplicate bag number is entered. When entering data in a form no error is generated when a duplicate bag number is entered. Is there a setting that will allow the same error to be generated on the form?

Reply | Quote

Replies

When you entered the duplicate bag number on your form did you try to save the record? I don’t see the message until an attempt is made to save the record. Are you asking to see the error message come up after a different action?
Carla

Reply | Quote

The record was saved but no error appeared. I only want the error to appear when the record is saved.

Reply | Quote

That is very strange. If there is a unique index on a table, you shouldn’t be able to save a record with a duplicate value for the index, whether directly in the table or in a form based on the table. So you now have two records in the table with the same value in the index?

Reply | Quote

Even though an error message does not appear, the rule of the index does not allow a new record to be added with the same bag number. So there is only one record.

Reply | Quote

First, you wrote “The record was saved but no error appeared”, now “Even though an error message does not appear, the rule of the index does not allow a new record to be added”. Which is it?

Reply | Quote

Do you have a SetWarnings False anywhere in your form code or perhaps in a macro? Or do you have error handling like “On Error Resume Next”?

Reply | Quote

Unless these two statements are added by default, they should not be anywhere in the form code.

Reply | Quote

They aren’t added by default, and they definitely should not be in your code, but it’s the first thing to look for when you don’t see an error message in a form.

Reply | Quote

In table view an error message appears and the record is not added. On a form, no error message appears and the record is again not added. The user of this little app needs some notification that the record he is trying to add was not successful because of a duplicate bag number.

Reply | Quote

Could you post a stripped down copy of your database? See post 401925 for instructions.

Reply | Quote

Here you go.

Thanks
Hans

Reply | Quote

The problem lies in the code behind the ‘returntomenu’ button. Because this has an On Error GoTo statement, errors while saving the record are suppressed (this is a bug in Access in my opinion). You can get around this by trying to save the record before closing the form (through the macro).

Private Sub returntomenu_Click()
On Error GoTo Err_returntomenu_Click

Dim stDocName As String

If Me.Dirty Then
RunCommand acCmdSaveRecord
End If

stDocName = “Return to Menu”
DoCmd.RunMacro stDocName

Exit_returntomenu_Click:
Exit Sub

Err_returntomenu_Click:
MsgBox Err.Description
Resume Exit_returntomenu_Click
End Sub

Reply | Quote

Those three lines of code fixed the problem. Many thanks HansV

Reply | Quote