auto-tabbing

G

Guest

Hi folks!

I found the perfect code yesterday for entering survey data and my form
seemed to be working was working but now it doesn't.

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

When I enter a 3-digit number into "Q_No" the cursor moves to "S1S1" but it
won't let me enter any numbers and the database crashes. If I bypass "Q_No"
and enter a number directly into "S1S1" the tab works fine for the rest of
the fields.

Can any one see what the problem might be? Is there something I am missing?

Cheers

--
http://www.patriotsquestion911.com
http://www.911truth.org
http://www.wtc7.net
http://www.st911.org
http://www.journalof911studies.com
http://www.pilotsfor911truth.org
http://ae911truth.org
 

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

Top