updating text field as form opens
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
Invoice2003.mdb
Invoice2003.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.