Tab sequence from the subform to main form

[roddy17]

I did a search and found a 'thread' on tab sequencing between forms and subforms. But i think that i need some more detail to explain please.
My subform has check boxes, two per record (a 'yes' or 'no' type of thing). The number of records in the subform will vary depending on the primary key in the main form.
What i need help with, is when the tab sequence reaches the last check box, that the tab sequence would then go to the command buttons (e.g. Save) on the main form.

thankyou

 

[Philly44]

Set the tab order of the button on the main form to be right after the tab order of the subform. I think that will do.

 

[roddy17]

well, i tried looking at the tab order again.
I have the subform as tab order 0 and cmdSave button as tab order 1. It's still not working yet. When i hit tab, it cycles through the check boxes of each record, as it should, but when it gets to the last record, it just goes back and forth between the check boxes of that last record.

 

[Guest_imported]

How about setting the subform's Cycle property to 'Current Record'. Alternatively, you could set the LostFocus event of the final checkbox as follows:

Forms!mainForm!cmdSave.setFocus

Where mainForm is the name of the Parent form.

Hope this helps...

 

[bc1234]

I have designed a few forms mainly for data entries. The data entry person has no knowledge of Access design view or anything Access. Can I lock the Design View on Forms so that she won't go there and moves/deletes check boxes, texts etc. accidentally?

Thanks.

 

[jgoodman00]

You can achieve this through Tools-Security, whereby you can create users & administrators & only the administrators could edit the forms...

James Goodman
j.goodman00@btinternet.com