missing data warning
- From: "Leslie Isaacs" <leslie.isaacs@xxxxxxxxxxxxxxxx>
- Date: Tue, 10 Jan 2006 12:39:13 -0000
Hello All
I have a form on which I want to warn the user when data is missing from
certain fields - but I need to allow them to proceed (i.e. close the record)
even without the data if necessary. I have tried setting the following event
procedure as the form's BeforeUpdate or AfterUpdate events:
If IsNull([fax].Value) And IsNull([add1].Value) Then
Beep
MsgBox ("Please enter an address and/or a fax number")
End If
but the problem is that if the user is updating the record by simply moving
to the next record (or by creating a new record by doing ctrl + as they are
in the habit of doing) the messagebox pops up but then the form moves to the
next (or new) record - so that they are in danger of adding the address/fax
data to the wrong record. I need somehow to prevent the movement to the
next/new record until the user has somehow 'accepted' the lack of
address/fax data for the current record.
I cannot see how to do this - if anyone could help I would be very grateful.
Many thanks
Leslie Isaacs
.
- Prev by Date: Re: Inserting a photo in a form
- Next by Date: Re: MouseWheel on/off ?
- Previous by thread: Re: Unbound textbox won't appear as currency
- Next by thread: Re: missing data warning
- Index(es):
Relevant Pages
|
