Dont Understand Why this is happenning.

[ChampionDuy]

I have a form that the users enters in case information including the case nuber which is the primary key. When the user enters in the case number and then tabs to the next field, It automatically saves the record. Meaning it tabs to the next field and then clears out the Id Field. Saving the record with just the ID and no other information on the case. I have no idea why it is doing this but it is very annoying. I have other forms that save information and when you type in the primary key, then tab to the next field it does not act like that. It just goes to the next field leaving what the users typed in the previous field and waiting for the user to click on save. How can I get it so when I tab it goes to the next field on the form and allows the user to type in the rest of information on the case and waits to save until the user clicks on save? I can explain more if needed I know this is a strange question.

 

[Daxton A.]

The Problem

The problem is when you created the form. Access gives you 3 different actions that the form can act as. They refer to what it does to your table. Make sure you have the right one selected. I know that this is true for Access 2000. Not sure about the others.

 

[boblarson]

Check your tab order. Go into the design view of the form and then select VIEW / Tab Order. You may see that your control that is your primary key, is the last in the tab order. So, in combination with Daxton's answer, you may need or want to change the tab order and the Enter key default.

 

[ChampionDuy]

I will check both, Thank you very much. I am actually surprised that you could understand the e-mail.

 

[ChampionDuy]

Thank you

It was the Tab order, Thanks so much, I was about to create a whole new form.