locki a form and opening in new field 2

[Jeanie]

I have a simple form that is set up with 20 questions and then a memo field for each question. I have left the fields on my form relatively big so that the person typing in the response can see most of what they have typed. Because of this, when you move to a new question the 'page' scrolls to the right. That is fine, but after you tab into the last question you can tab to the 1st question in a new field. What I want, is that once you reach the last question, I don't want tab to bring you anywhere. I want the user to have to click on a button to save that form and go to the next/blank form. This way someone won't accidently enter information onto the wrong record.

The other thing I want is that I have set it up so that when they open the data-base the form pops up on front. But, it pops up at the 1st record and I want it to pop up at the 1st blank record.

Any help would be appreciated!!

Thanks,

Jeanie

 

[ChemistZ]

To get the form to pop up at the first and only blank record, alter your form's properties so that Data Entry is set to "Yes".

 

[ChemistZ]

As for stopping Tab from going to a new record, change the Cycle property of the form to "Current Record" and when someone is in the last question and hits Tab it will go back to the first field within the same record. Then add button to save the record and open up a new version of the form.

 

[Zeroanarchy]

Something else you could add is in the last field say it is a textbox

In the afterupdate
add the following expression:

=[Command2].OnClick

* rename command2 to the name of the close button.

What this will do is on tab from the last field it will automaticly do the code behind your close button on click.

hope this helps

Zero