Cancel NEXT automatic property

A

an

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
 
T

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.
Click to expand...

try to change the Cycle Property of your form.

HTH.

Thomas
 
S

SiJP

Just to clarify:

"When click in last field, change to next record"
Click to expand...

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
 
A

an

SiJP

Thanks for your reply.
I don't understand:

Text4 and Text1

Grateful
an

SiJP said:
Just to clarify:

"When click in last field, change to next record"
Click to expand...

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
Click to expand...
 
S

SiJP

Text4 and Text1 are the name's of potential fields - you will possibly
have these named differently.

If Thomas's suggestion worked ok, go with it!

Cheers,
 
Top