Event For Next Record

[andi]

how and where if we want to make Event when next record,?

 

[arnelgp]

do you mean goto next record:

docmd.GoToRecord ,,acNext

 

[andi]

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

 

[Galaxiom]

The Form Before Update Event fires before the current record is committed.

 

[andi]

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

 

[andi]

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

 

[prowaseem]

can you be more specific plz ? i dont understand what you asked, and all the answers too that everyone gave you in this forum !