Cancel NEXT automatic property

[Guest]

Hello!

I have a form with many fields but only four to data entry.
When click in last field, change to next record.
I would like cancel this property and only change next record trough command
buton: NEXT RECORD.

Thanks in advance.
an

 

[Thomas Winkler]

Hi,

I have a form with many fields but only four to data entry.
When click in last field, change to next record.
I would like cancel this property and only change next record trough command
buton: NEXT RECORD.

try to change the Cycle Property of your form.

HTH.

Thomas

 

[SiJP]

Just to clarify:

"When click in last field, change to next record"

If I understand you correctly, you are saying that when you click your
mouse in this field, the database moves to the next record? If this
is so, then you more than likely will have an on_click event behind
this field.

If you mean that after you move off of this final field, which I
suspect is what is happening, then you can add some simple code to
manage this:

Private Sub Text4_LostFocus()
Text1.SetFocus
End Sub

 

[Guest]

TW,

Thanks for your help.
Work fine
an

Hi,


try to change the Cycle Property of your form.

HTH.

Thomas

 

[Guest]

SiJP

Thanks for your reply.
I don't understand:

Text4 and Text1

Grateful
an

Just to clarify:

"When click in last field, change to next record"

If I understand you correctly, you are saying that when you click your
mouse in this field, the database moves to the next record? If this
is so, then you more than likely will have an on_click event behind
this field.

If you mean that after you move off of this final field, which I
suspect is what is happening, then you can add some simple code to
manage this:

Private Sub Text4_LostFocus()
Text1.SetFocus
End Sub