Form not switching between subforms

[newtoaccess2]

Good afternoon,



I am very new to access. I have created a form with multiple subforms (each subform was added using the subform wizard) to be used for data entry. When entering data, I am able to tab down through the main form into the first subform and then I cannot tab into the other subforms. If I manually click on the next form I can enter data, but the same thing happens I get stuck within that form unless I manually click on the next. How can I tab down through the various subforms to enter data? I have used the tab control to create the same type of form, but for this form I need it to be identical to the data entry form used in the field, i.e. it cannot have tabs).

Database Info: Tables are all linked one to many using Survey ID as the primary key in the main table (Survey Location Info) and Survey ID as the foreign key in the subsequent tables (i.e. survey weather conditions, observation details, etc. Join type for each is "Include ALL records from 'Survey Location Info' and only those records from 'Survey Weather Conditions' where the joined fields are equal". When creating the subforms with the subform wizard, the subforms were linked via the Survey ID field (i.e. Survey Location Info - master field = Survey ID and Survey Weather Conditions - child field = Survey ID) I hope all this makes sense. Also I have not used code at all so I would be lost in that area.

Any help someone could provide would be greatly appreciated.

Thanks!!!

[Missinglinq]

...I am able to tab down through the main form into the first subform and then I cannot tab into the other subforms...

What happens when you try? Are you talking about tabbing through the Controls of the Main Form, tabbing to the first Subform, tabbing through its Controls, then attempting to tab into the second Subform? If so, where does the cursor go when you attempt this last step?

Linq ;0)>

[burrina]

Here is an Example:

Forms!MainForm![Subform].Form.SetFocus

HTH

[newtoaccess2]

Linq- thanks for your reply. I can tab through the main form controls and into the first subform, but then I can only tab through the controls in the 1st subform. If I manually click on the 2nd subform, I can tab through only those controls and so on. Is there a way to tab through the controls of each subform and then go directly to the next subform without doing it manually? Also the tab order is correct. Please keep in mind I know nothing about code so if it requires code I'm gonna need a lot of direction. Thanks!!!!!!

[Missinglinq]

I'm not certain, about this, but in Form Design View, for the Form the Subform is based on, go to Properties - Other and check the Cycle Property; of it's set on 'Current Record' change it to 'All Records' and see if that helps.

Linq ;0)>

[June7]

In my experience, cannot tab between subforms.

I thought Alt+character shortcut worked for selecting tab control pages - if it did in 2007, doesn't in 2010.

[newtoaccess2]

@ missinglinq; Thanks for the reply! Unfortunaly, I have tried changing the cycle property in both forms. It allows me to cycle through all of the individual records for that form, but doesn't allow me to tab to the next subform. Thanks for the help!

[newtoaccess2]

@ burrina, thanks for replying! I have seen this code used before in other forum posts, but I'm unsure how to apply it. Should it be entered under a specific event property? Or does it need to be entered in VBA with additional code? I'm unfortunately new to Access and writing any type of code. Any advice or direction you could provide would be greatly appreciated!!

[June7]

burrina's code could possibly be in the Exit event of the last control on subform. I use only VBA, not macros. So select [Event Procedure] in the event property and click the ellipsis (...) to open VBA editor at the procedure. Type code.

[newtoaccess2]

Thanks June7!!!! I'll give it a try.