Change recordsource of susequent subforms-TJ

  • Thread starter Thread starter ambushsinger
  • Start date Start date
A

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