Required Field - Suppress Error Message

[Craig Ferrier]

If i have a form that has a field from a table that is a required field.
Can I suppress the Access error message in replacement for an error message
in a form_before_update event.

 

[Dennis Schmidt]

Hi Craig,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

You can't turn the internal error checking off, so what you would have to
do is not set that value in the table. Instead, as you suggested, check
for the value on the BeforeUpdate of the form.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support

 

[Craig Ferrier]

I have a subform(donations) within a form(donors) (linked by child/master
fields)

If a new donation record is started, there are 4 fields that are required
before the user can go to another record. (donor or donation)

Can you point me in the right direction on how to implement this.

Everything that I have tried doesnt seem to work.

I am using :

If IsNull(me.Date) then
MsgBox " text ", vbcritical, "title"
docmd.gotocontrol "Date"
End If

I have these for each of the 4 field on the suborm before update event.

Again if anyone can point me in the right direction it would be appreciated.

Craig