Check all records before closing

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

Guest

Please help...
I have a form that comes up in add mode only. Users can start an entry and
go to a new record to start a new entry before being complete. This is needed
in our organization. They can open as many records as they wish, and can
always navigate back to the first ones to finish them. My close button checks
each field that absolutlely must be filled out, and gives the user a message
that the field needs to be completed if it is Null. It then cancels close and
sets focus to that field. Here's my problem, the code only works for the
record they are on when they close the form. If they are on record 4, and it
is completely filled out, it will close even though record 1,2,and 3 are not
completed. One possible solution would be to have a new form come up for each
record, so that close will check it and only close that one. I'm not sure how
to do that. I have also been told that I should use RecordsetClone to have
the code check each record before closing, but I am not sure how to write
this. Any advice would be appreciated.
 
Seems to me that the checks you put into close really ought to be in the
form's beforeupdate event. Hope this helps.

Tricky
 
Back
Top