auto-tab (part 2)

[Guest]

Hello,

the problem I outlined in the earlier thread is happening again.

The first field is called "Q_No". In the "On Change" event for this field I
have the following:

If Len(Me![Q_No].Text) > 2 Then
Me![S1S1].SetFocus
End If

There must be a problem with the "Q_No" field but I don't what it might be.
Can any one see what the problem might be? Is there something I am missing?

Cheers

 

[BruceM]

I didn't see the earlier thread, but did this code compile correctly? If
Q_No is the name of the control, it should work, although it may not if it
is also the name of the field.

 

[Guest]

I changed the name of the control and that sorted it.

thanks

I didn't see the earlier thread, but did this code compile correctly? If
Q_No is the name of the control, it should work, although it may not if it
is also the name of the field.

Hello,

the problem I outlined in the earlier thread is happening again.

The first field is called "Q_No". In the "On Change" event for this field
I
have the following:

If Len(Me![Q_No].Text) > 2 Then
Me![S1S1].SetFocus
End If

There must be a problem with the "Q_No" field but I don't what it might
be.
Can any one see what the problem might be? Is there something I am
missing?

Cheers