Complete Form before Next Record

  • Thread starter Thread starter bw
  • Start date Start date
B

bw

I have a "Status" field that executes a procedure on Lost Focus, which esentially makes
other fields visible, depending on the value of "Status".
Is Lost Focus the right procedure for this?

When these other fields are visible, I want to make sure they all have valid data in them,
before moving on to other fields and/or records.

I don't need the code to do this (I don't think), but I do need to know which procedures to
use...and where?

Do I use field level procedure, or form level procedure and which ones??

Thanks for any advice.
Bernie
 
I have a "Status" field that executes a procedure on Lost Focus, which esentially makes
other fields visible, depending on the value of "Status".
Is Lost Focus the right procedure for this?
Click to expand...

As a rule, I'd say no. Lost Focus fires even if the user is just
tabbing through not doing anything to the field value at all, and
won't fire at all unless they setfocus to the control in the first
place.
When these other fields are visible, I want to make sure they all have valid data in them,
before moving on to other fields and/or records.
Click to expand...

The Form's BeforeUpdate event (which has a Cancel property which you
can set to True to cancel the update) is the safest place for this.
I don't need the code to do this (I don't think), but I do need to know which procedures to
use...and where?

Do I use field level procedure, or form level procedure and which ones??
Click to expand...

I'd use both: the AfterUpdate event of the Status field, to change the
visibility/enabled properties of the other controls when the user
changes the status; and the Form's Current event, to change their
properties when the user navigates to an existing record.
 
Thank you, sir!

I have implemented your suggestions, and they work fine now.

I appreciate your help.
Bernie
 
Back
Top