Event For Next Record

andi

New member
Local time
Today, 19:26
Joined
Apr 20, 2016
Messages
8
how and where if we want to make Event when next record,?
 
do you mean goto next record:

docmd.GoToRecord ,,acNext
 
i mean,
i have maked a unload Event for validation before close form,
but it is not availalbe for next record.

example; i have a form that have to fill a "textbox1"
if textbox1 is null will show a message box

i write macros on unload Event like this.

IF Isnull(textbox1) or [textbox1] = "" then
messagebox:
prompt: "xxxxxxxxxxxx"
beep : Yes
Type : Warning
Titel : Warning

cancel Event

end if


so that not available for next record

how and where i have to write a macro if i want it available for next record too..

im sorry my speak english is bad.

thank you
 
The Form Before Update Event fires before the current record is committed.
 
if i write thats macro to before update Event, when i klik close button, after msgbox showed will show warning save prompt like this attachment
 

Attachments

  • warning close.png
    warning close.png
    5.5 KB · Views: 119
or, may be, anybody can help me how to show msgbox validation for textbox1 (or one of textboxs) in macro not in VBA when close, next record, previous record, print, or save
 
can you be more specific plz ? i dont understand what you asked, and all the answers too that everyone gave you in this forum !
 

Users who are viewing this thread

Back
Top Bottom