Before Update event for Form

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

Guest

Why is it I cant use 'setfocus' in this event? I validate field contents here
and would like to set the focus to fields that are invalid. Am I doing this
wrong? Is there a better way? Thanks.
 
mscertified said:
Why is it I cant use 'setfocus' in this event? I validate field contents here
and would like to set the focus to fields that are invalid.
Click to expand...


Can't tell what's wrong without seeing the event procedure,
but what you are describing is the normal way to do it.
 
I have had the same problem... The work around that I found was that I put
the code in the AfterUpdate event and if it is not what I want, I use the
DoCmd.CancelEvent and then SetFocus.

It seems to work this way.

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to avoid endless loop? 2
Setting the Focus on a Control 5
How to get data from an unbound control? Why doesn't SetFocus work? 6
Setfocus to same field 4
Sub Sub Form control set focus 2
Backtabbing between SubForms on TabControls 2
Access Problem: Combobox.setfocus fires combobox.OnClick event 5
on click event - subform visible or no 1

Back
Top