undyingking (![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
undyingking) wrote2005-09-02 01:18 pm
undyingking) wrote2005-09-02 01:18 pm
Entry tags:
MS Access whizzes?
A friend has a problem in Access, and I can't see how to get round it so I wondered if any of you might.
He has a form which contains two subforms. What he wants is for one of the subforms to page in response to the other, ie. when you select a record in the first subform, the second one automatically changes to display the data corresponding to that record.
(Why he wants to do this rather than just controlling it in the main form I don't know, but there you go.)
I can't see anyway of binding the two subforms together directly -- is there one? -- so I was thinking maybe it could be done by writing a procedure for the first subform's OnGotFocus such that the second subform does a corresponding GoToRecord. However I'm having toruble making this work, because my VBA is (a) very rusty, (b) on an earlier version, and (c) was never much good in the first place. Plus I'm not even sure if this is the right approach -- any thoughts?
He has a form which contains two subforms. What he wants is for one of the subforms to page in response to the other, ie. when you select a record in the first subform, the second one automatically changes to display the data corresponding to that record.
(Why he wants to do this rather than just controlling it in the main form I don't know, but there you go.)
I can't see anyway of binding the two subforms together directly -- is there one? -- so I was thinking maybe it could be done by writing a procedure for the first subform's OnGotFocus such that the second subform does a corresponding GoToRecord. However I'm having toruble making this work, because my VBA is (a) very rusty, (b) on an earlier version, and (c) was never much good in the first place. Plus I'm not even sure if this is the right approach -- any thoughts?