TABBING CREATES A NEW RECORD!?! 1

[Harr777]

Greetings,

I have a form that opens up to a new record. It is set on data entry. Somehow, when I finish tabbing through all of the fields on the form, it goes to a new record!
Anyone know why?

 

[KenReay]

Hi

You need to look at the .dataentry property and teh cycle property of the form

Understand what they do and then decide what settings you need based on how you want the form to behave

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[bostonfrog]

You also need to check the options you set under Tools | Options, and one of the tabs allows you to set the behavior certain keys like ENTER and TAB. By default, though, when you reach the last field in a record on a form and tab, it will take you to the next record. Go the Options menu.

 

[Harr777]

Thanks for the help.

Now that I'm aware of the cycle setting, I was able to look up in Help and found this about the three settings for Cycle:


All Records 0 (Default) Pressing the TAB key from the last control on a form moves the focus to the first control in the tab order in the next record.

Current Record 1 Pressing the TAB key from the last control on a record moves the focus to the first control in the tab order in the same record.

Current Page 2 Pressing the TAB key from the last control on a page moves the focus back to the first control in the tab order on the page.

Seems like it might have been better to have the second as the defualt (At least better for me!)

 

[quest4]

Harr777, thanks that just solved my big mistery, I have been pulling my hair out for a couple ofdays now and that just cured it.