Selasa, 12 Oktober 2021

[MSAccessProfessionals] On Load or On Current populate fields on a report for printing

Good morning - 
Due to personal issues I've not worked on my software for too long... 
Hoping to get back on the task... 
I've not worked much with reports, and I have never been clear on when to use on load, and on current procedures.  

Specifically I have a form that I sent to a report and then print.. 
Several of the fields may be blank, for example the Warranty Note, 95% of the work orders use a standard note, the remainder will have something other.. 

If Warranty Note = Null Then 
    Standard Note
Else 
    Custom Note
End If

Should this be in the On Load or On current event procedure

Take care,

Mike the Plumber

Sac City Plumbing


Tidak ada komentar:

Posting Komentar