Coordinating tabs

S

Sian

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?
 
W

Wayne-I-M

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
 
T

Tom Wickernards

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

George Nicholson

Pay no attention to the ugly troll under the bridge.

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

Tom Wimpernads

Wayne;

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

Tom Wimpernads

im not a twit bitch



George Nicholson said:
Pay no attention to the ugly troll under the bridge.

(Pretty sure this is just Aaron being a twit again.)
Click to expand...
 
S

Sian

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!
 
Top