Use of tab key to travers fields

[koolguy]

Hi,

I am currently working on a database that stores customer details and order details. the back end is SQL Server and the front end is MS Access.

I have recently come across the following problems:

First of all, in one of my order forms (which has a couple of text fields and drop down lists) I am unable to traverse through the text fields using the TAB key.

when I use the TAB to goto the next field it deletes the previously entered data in other fields. how do I specify the order of fields to use the tab key?

secondly, after i have saved a record and I get back to edit, it comes up with a warning saying that the record was previously changed by someone else and it doesnt let me change any field. Having looked into the Lock features I found the following :

1)Default open mode as 'Exclusive'.

2)Default record locking as ' No Locks'

3)Open the database using record level locking.

can anyone help me out with these issues?

 

[RuralGuy]

You can view and change the tab order of your form by going to View>Tab Order... while in design mode of the form. As for deleting previously entered data in some of your controls, you must have some code in maybe the Exit or LostFocus event of your controls to make that happen.

 

[missinglinq]

when I use the TAB to goto the next field it deletes the previously entered data in other fields.

You're not deleting the data, you're moving to a new record! In Design View for your form, goto Properties - Other and change the Cycle Property form All Records to Current Record.

Linq

 

[koolguy]

hi thr,

Thanks ruralguy! with your advise I was able to sort out the tab order issue but for the solution mentioned by you and missinglinq for the record locks i had no luck . i havnt yet created an on lostfocus event and when i change the cycle property to current record i get the same error. it totally ignores it.

 

[RuralGuy]

...secondly, after i have saved a record and I get back to edit, it comes up with a warning saying that the record was previously changed by someone else and it doesnt let me change any field.

How do you "...get back to edit"? If you close the form and open it again, will it let you edit? How are you saving the record?

 

[missinglinq]

We are sure we're hitting the <Tab> key here, aren't we? I know there's all kinds of strange keyboard configurations out there, and hitting <Esc> (which is just above my <Tab> key) will delete previously entered data.

Other than that, given the facts posted and the things tried, I'd have to start leaning towards a corrupted form.

 

[RSW]

You're not deleting the data, you're moving to a new record! In Design View for your form, goto Properties - Other and change the Cycle Property form All Records to Current Record.

Linq

I am an occasional user of this forum; I just wanted to mention that I was having this very same problem, and a quick Google search brought me here to the answer. Thanks!!

 

[missinglinq]

Glad we could help you, RSW! I really don't know why Micro$oft thought that making Cycle All Records the default was the thing to do! I see this question half a dozen times a week. Now if we could just figure out what in the world is going on with koolguy!