View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ISS6 ISS6 is offline
external usenet poster
 
Posts: 7
Default Exit Field vs Exit Button......

Yes, this name field is required and the edit logic was built on the idea
that there was no point in continuing to other fields when the "#1" field was
incorrect.

I was hoping that there would be some control I could test within the name
edit routine to check if the even was triggered when the Exit button had been
pressed. That would greatly simplify things, but I haven't been able to find
the right condition.

I know it must be there - just out of the grasp of my feeble mind.......

"Bill Renaud" wrote:

<<If the cursor is positioned on the Name field, execution goes to the
txdtName_Exit routine before exiting!

This is probably because the focus on the form is exiting the Name field to
go to the Exit button.

Maybe you could just move the code from the txtName_Exit routine to the
ExitButton_Click routine. Do you really need to check the value the moment
the user leaves the field to change something else. Maybe they are going to
come back and correct the Name field before finalizing their input anyway.
Or is the Name field required to be correct before other fields can be set
properly?

--
Regards,
Bill Renaud