Can't tab through datasheet subform

  • Thread starter Thread starter rocketD
  • Start date Start date
R

rocketD

Hello,

I have a form containing data from 2 tables. I display the
demographic data in the main part of the form, and the tracking data
for surveys taken in the subform (in datasheet format; there are 5
fields, and parent/subform are linked by participant ID). What you'll
see is name, contact info in the parent form, then for that person,
each survey they've completed in the subform. Everything displays
fine, but I'd like people to be able to easily add records directly
into the 5 fields of the subform when a new survey is completed.

But...when I tab into the subform from the parent form, I can only
edit the first field. If I try to tab to the next field in the
datasheet, it will tab out to the main form. I can't even use arrows
to advance to the next field in the subform. Arrows or tab
automatically takes me to the next control on the parent form, so the
only way to edit the records is by clicking with the mouse in each
field of the datasheet - inefficient! I've messed with the Cycling
property to no effect. Any suggestions?

Thanks,
Dara
 
rocketD said:
Hello,

I have a form containing data from 2 tables. I display the
demographic data in the main part of the form, and the tracking data
for surveys taken in the subform (in datasheet format; there are 5
fields, and parent/subform are linked by participant ID). What you'll
see is name, contact info in the parent form, then for that person,
each survey they've completed in the subform. Everything displays
fine, but I'd like people to be able to easily add records directly
into the 5 fields of the subform when a new survey is completed.

But...when I tab into the subform from the parent form, I can only
edit the first field. If I try to tab to the next field in the
datasheet, it will tab out to the main form. I can't even use arrows
to advance to the next field in the subform. Arrows or tab
automatically takes me to the next control on the parent form, so the
only way to edit the records is by clicking with the mouse in each
field of the datasheet - inefficient! I've messed with the Cycling
property to no effect. Any suggestions?
Click to expand...


Check the following properties of the controls on the subform:

Enabled (on the Data tab of the property sheet)
Tab Stop (on the Other tab of the property sheet)

Both of those properties should be set to Yes in order to enable tabbing
into the control.

If the properties are currently set to yes, then I suspect there is code or
a macro involved, maybe handling the KeyPress or KeyDown event of either the
subform, or the subform control, or the controls on the subform.
 
Check the following properties of the controls on the subform:

    Enabled  (on the Data tab of the property sheet)
    Tab Stop (on the Other tab of the property sheet)

Both of those properties should be set to Yes in order to enable tabbing
into the control.

If the properties are currently set to yes, then I suspect there is code or
a macro involved, maybe handling the KeyPress or KeyDown event of either the
subform, or the subform control, or the controls on the subform.

--
Dirk Goldgar, MS Access MVP
Access tips:www.datagnostics.com/tips.html

(please reply to the newsgroup)- Hide quoted text -

- Show quoted text -
Click to expand...

They were both enabled, but since I was poking around in the subform,
I started looking at the fields in it - they all had the correct
order, which I had set, but for some reason the tab stops were
automatically set to No. I changed them to Yes for each field, and
now the tabbing works.

Thanks!
Dara
 
Back
Top