troubleshooting Question

updating text field as form opens

Avatar of Chrisjack001
Chrisjack001Flag for United States of America asked on
Microsoft Access
1 Comment1 Solution267 ViewsLast Modified:
On the subform “subTimeEntry” when a Study ID is selected, the doctor “PI” full name and “Study” title fields display and are greyed out. I want these fields to populate when the form is opened initially and after. As it is right now it only populates after you make a selection. These fields are found in the “Studies” table under the “PIID” and “Study” field respectively. How can I accomplish this goal to populate upon opening and after. Attached is a copy of my database. Thanks in advance
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros