Change recordsource of susequent subforms-TJ

[ambushsinger]

I have a subform with a combo box containing User ID's ("CKENT"). The next
suform will be the user profile with listbox ("Coordinator" or "Inspector")
etc...based on the user id and a check box to show the current profile of the
selected user.
The next subform will be Contract number which shows the current contract
number being worked on.
When I change the User ID ("BWAYNE") the user profile recordsource should
update and populate the user profile and the contract number.
Any ideas???

TJ

 

[ErezM via AccessMonster.com]

hi
if i got you right, you have 3 subforms on 1 main "parent" form? and you want
subforms 2 and 3 to reflect the changes made in subform 1
what you can do is set an unbound hidden field on the main (parent) form to
the chosen value in subform 1, and set subforms 2 and 3's RecordSource to
link to that unbound textbox

then inside subform 1's combo box AfterUpdate event, write "Me.Parent.Form!
TextHiddenValue=MyChosenUserID"
and requery both forms 2 and 3

i hope it makes sense to you, tell me if you need more details

 

[ambushsinger]

Yes...Thank you
It makes perfect sense. Surprises me I didn't think of it.
Thanks for taking the time.
By the way...it worked perfectly.

Tom