BeforeUpdate and closing form

[LEXCERM]

Hi,

I have the following code in a BeforeUpdate event of a field:-

cmd_PONumberSearch_Click 'activates requery from button
With Me.txt_PONumber
.SelStart = 0
.SelLength = Len(Me.txt_PONumber.Text)
End With
Cancel = True

This is used for continuous searches in a subform and sets focus back on the text field to make it easier for the user.

Problem being, if this field has the focus I cannot close the form via a command button.

What is the trick here?

Kind regards.

 

[ranman256]

I dont see the point of this code....it highlights the text in a box, then does nothing.
why?

 

[LEXCERM]

Hi ranman256,

It saves an extra 'click' selection in the field before entering the next value. Especially if you have many PO's to check.

 

[ranman256]

why the
Cancel = True
???
you didnt do anything to warrent this.

 

[HiTechCoach]

Problem being, if this field has the focus I cannot close the form via a command button.

What is the trick here?

Kind regards.

In the code for the command button that closes the form, move the focus to another control before closing the form.
Example:

Me.MyControlName.SetFocus

or

Docmd.GoToControl "MyControlName"