key tab control for subfrom

  • Thread starter Thread starter Revned
  • Start date Start date
R

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
 
Revned said:
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
Click to expand...


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.
 
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
 
Revned said:
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
Click to expand...

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.
 
Back
Top