create a field that must be filled in by user

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an edit record form and I want to force the user to enter notes in the note field every single time they make a change to any of the other fields.
 
Build code in the beforeupdate event that checks the form to see if it is
dirty. If it is, and the Note.value and Note.oldvalue are equal, pop up an
error and cacel the update.


I have an edit record form and I want to force the user to enter notes in
the note field every single time they make a change to any of the other
fields.
 
I'm sorry, but I'm relatively new to Access so I'm not sure how to do that. Could you explain? Thank

----- Rick B wrote: ----

Build code in the beforeupdate event that checks the form to see if it i
dirty. If it is, and the Note.value and Note.oldvalue are equal, pop up a
error and cacel the update


I have an edit record form and I want to force the user to enter notes i
the note field every single time they make a change to any of the othe
fields
 
Back
Top