Auto populating multiple fields

I have a form called “Scheduling-Add”. When the user wants to add a new “Study” that is not in the system they click the “Studies” button on the form which opens another form called “Studies-Add” . When the user is filling the details on this form for the new studies, the record is automatically populated with a “studyAutoNbr” which is also the primary key in the upper right field of the form next to the “Close” button. This “studyAutoNbr” is automatically populated in the “Protocol Nbr” field. I also want this number populated in the “Study ID” field. Example if the new record about to be created has a new “AutoID” of 12355. This same ID “12355” is populated in the “Protocol Nbr” field and should be populated in the “Study ID” field. How can I accomplish this goal. Attached is a copy of my database with the form. Thanks in advance.
Invoice-7-7-2001-91611.accdb
Chrisjack001Asked:
Who is Participating?
 
Mudasir NooraniSenior Analyst ProgrammerCommented:
yes it will autopopulate both the protocol and the studyID fields. Like I mentioned before, you should put that piece of code after the first line of the code in the form_load event of the Studies-Add form.

This is what your form_load event should look like:

Private Sub Form_Load()
    Me.txtProtocolNbr = Me.StudyAutoNbr
    Me.Text39 = Me.txtProtocolNbr
End Sub

Hope this helps.

ref-IT
0
 
Mudasir NooraniSenior Analyst ProgrammerCommented:
Hello Chrisjack001,

I downloaded your database and had a look at the form_load event of the Studies-Add. Since the text box that represents Study ID is called Text39 (this is not a good convention, you could do better by changing the name of this text box to something like txtStudyID), you can add the following snippet after the first line of code in the form_load event:

Me.Text39 = Me.txtProtocolNbr

and it will resolve your problem.

Hope that helps.

ref-IT
0
 
Chrisjack001Author Commented:
So will that number populated in the “studyAutoNbr” automatically populate in both the protocol and studyID fields?
0
 
Chrisjack001Author Commented:
where should I put this code. In what property event?
0
 
Chrisjack001Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.