key tab control for subfrom

[Revned]

hi,

i have a subform under my main form "OrderEntry"
i set the mainform DataEntry,Allow Edits,Allow Additions to Yes
i want to control the key Tab so that by accident if user press the key Tab
it will not automatically saves the data and clear the subform

hopefully i make myself so clea, i am using access 2003

thank you very much

 

[Dirk Goldgar]

hi,

i have a subform under my main form "OrderEntry"
i set the mainform DataEntry,Allow Edits,Allow Additions to Yes
i want to control the key Tab so that by accident if user press the key
Tab
it will not automatically saves the data and clear the subform

hopefully i make myself so clea, i am using access 2003

I'm not sure I understand you, but I think you just need to set the form's
Cycle property to "Current Record". You'll find it on the "Other" tab of
the form's property sheet.

 

[Revned]

I mean the Tab key that is in the keyboard
i just want that enter a data press Tab in the keyboard
it will stop on the next line until user enters a data again

thank you Dirk Goldgar, sorry for making you confuse

 

[Dirk Goldgar]

I mean the Tab key that is in the keyboard
i just want that enter a data press Tab in the keyboard
it will stop on the next line until user enters a data again

Did you look at the Cycle property? It controls what happens as the user
tabs out of the last control in the form's Tab Order. It can be set to "All
Records", "Current Record", or "Current Page". The default is "All
Records", meaning that as you tab out of the last field on the form, the
form automatically moves to the next record. If you set it to "Current
Record", tabbing out of the last field will move the focus to the first
field, but on the same record.

I do think that's what you want. It would be possible to have the tab key
completely ignored on the very last field in the tab order, but it seems to
me that would be more trouble than it's worth, if the Cycle property does
what you need.

 

[Revned]

yes thank you Dirk Goldgar i did as what you suggested

thank you very much