Tab Issue

[Lazor78]

Hi



I am new to Access 2010 and am having issues with a tabbed navigation form - i want the first tab to control the record for all the others i.e. if i select a member of staff in the first tab, all the other tabs when opened will display their record. I can get this to work in a split form with inserted tabs but not on a plain horizontal tabs navigation page.

I have attached an example of the form i am trying to create.

Can anyone help?

Thanks

Paul

[Missinglinq]

If I understand you correctly, and

• Your first Form is frmStaff
• The names of the Controls holding first name and surname are the same on all Forms
• The frmStaff remains open while opening the other Forms

you can place this code in each Form:

Private Sub Form_Load()
 Me.Filter = "[State] Like '*" & Me.OpenArgs & "*'"
 Me.Filter = "[FIRST NAME] = '" & Forms(frmStaff)![FIRST NAME] & "'" & " and [SURNAME] = '" & Forms(frmStaff)![SURNAME] & "'"
 Me.FilterOn = True
End Sub

BTW, you probably need to update your profile for this forum, as it still says that you are using Access 2003.

Linq ;0)>

[Lazor78]

Thanks, worked a treat.

[Missinglinq]

Glad we could help!

Linq ;0)>