Coordinating tabs

[Guest]

Please help! I have a Client form, with two tabs containing subforms. One
shows a data table with a list of jobs for that client. What I want to be
able to do is click on a job in the list , click on the other tab, and have
all the fields displayed from that job ready for editing.

I cannot work out how to do this one simple thing! Or even where to start
(should I be reading up on recordsets, for example?) Any suggestions?

 

[Guest]

Hi Sian

The best bet would be to have the 2nd subform as a subform of the 1st.
Or
Use the 1st subform to fill in a hidden text box on the main form and have
the 2nd subform linked to this - hope that make sense.

Your 1st subform would have an OnClick event to filter the 2nd subform like
this

Private Sub Form_Click()
Forms!MainForm!HiddenField =
Forms!MainForm!2ndSubForm.Form!LinkingFieldOn2ndSub
DoCmd.GoToControl "2ndSubForm"
End Sub

 

[Tom Wickernards]

if you want to coordinate tabs; then you will need to move to SQL Server and
/ or Access Data Projects

 

[BruceM]

Incorrect.

if you want to coordinate tabs; then you will need to move to SQL Server
and / or Access Data Projects

 

[Guest]

Hi Tom - are you sure ? they seems to work fine for my "stuff"

 

[George Nicholson]

Pay no attention to the ugly troll under the bridge.

(Pretty sure this is just Aaron being a twit again.)

 

[Tom Wimpernads]

Wayne;

well state-side-- Access MDB isn't reliable enough for real world usage

 

[Tom Wimpernads]

im not a twit bitch

Pay no attention to the ugly troll under the bridge.

(Pretty sure this is just Aaron being a twit again.)

 

[Guest]

Thank you so much! This has been bugging me for days. I used your
suggestion of a hidden field in the main form, which I used as the master
control for the second subform. Works beautifully!