Form Glich

  • Thread starter Thread starter Ldhamric3
  • Start date Start date
L

Ldhamric3

I created a form where in I can go in and enter yes or no questions somewhat
like a survey. There are a fields, so that it actually created two columns
from the table when it created the form. There are actually two problems.
The first one is the biggest one. At the top of the column there is a slot
to enter the name of the person that is being surveyed, and those people
being surveyed are being drawn from another table so I don't have to retype
everyone's name everytime. For some reason when I get to the bottom of the
first column instead of tabbing over to the top of the next column it goes
back up to the name box at the top of the first column, if you tab a second
time it will go to the second column. As you can see if I am typing Y for
yes and hitting tab very quickly, and it goes to the name function, it will
change the name to someone whose last name starts with Y such as Yang. Then
I end up accidentally creating a bunch of surveys for Mr Yang. This isn't a
big deal since I am aware of the problem, but I want to fix it, to prevent
other people from making this mistake inadvertantly when they are using the
form. Can anyone offer any ideas where I might have made the mistake and how
I can fix it.

Thanks.
 
For the control where the name is displayed, set the Enabled Property to No
and the Locked Property to Yes. The user will not be able to alter the name
at all.

Then to speed up you entry, rather than a Text box where you type a Y, use a
check box. Then all the user has to do is click it for Yes or leave it blank
for No.

The issue you will have, though is if your table is expecting a text value
of Y or N, you will need to change to table to use the Boolean values of -1
for Y and 0 for N.
 
Back
Top