False combo through update

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

Guest

This seems simple but I can't find a way.
I have a 2 column combo. Limit to List True. In After update a lot of
calculations that set up the following text boxes. If a user just tabs or
clicks on another control the text box dosn't update. It also dosn't check
the list or the validation rules.
On exit wont work as it goes through there to often as it is the first
control on the form. I've tried putting defaults in and validation rules but
can't stop it.
Please anyone with any ideas thanks.
 
I had already tried it. If the control is unused just click on another box or
tab or enter it allows it . if however an entry is made and undone back to
Null then it works. I cant check the value is required in the table as it is
being used to lookup values from a autonumber field. I did use the validation
property to check for Null.
At the moment I think the only way around it is to check it in the on enter
of every other control.
 
I think you are pretty close, and Alex's idea will work with a little
modification.
Set the combo box Default Value to Null.
Use the After Update just as you are
Use the Lost Focust event of the combo to see if it is null and if so,
require an entry
Set the combo's value to Null in the Current event so it will be ready for
the next record.
 
Still a problem. It works fine except once you have trapped it you can't
setfocus back to the combo. Neither setfocus or gotocontrol worked. I ended
up setting focus to the next control which trapped it again and sent it to
the combo.
Thank you both for your help .
 
Back
Top