How to click on a listing of dates within a form/subform and have the form go to that date?

I have a form call ProgressNote which consist of a subform of 4 tab controls - works great.
On the ProgressNote form I have another subform called ServiceDates - the subform is pulling in the correct ServiceDate value.
I would like to be able to click on anyone of the ServiceDates in the subform and the ProgressNote form will go to that record for that date.  How do I do this.  I have included a screenshot of my form along with notes (data is fictitious).

I would greatly appreciate any help/instructions.

Thanks
ServiceDates-subform.docx
donvike1Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ASP8MBMCommented:
Many ways, but I have done something similar recently:

1) The data source of your subform must be dependent on the on the ServiceDate value(include the date in the query or the SQL string)

2) have an event built for the ServiceDate (I am assuming it is a text control), and upong Clicking (Use Click_Event) you requery your subform(yourSubform.Requery)

You can also use filters....
0
donvike1Author Commented:
Ok, my data source for the subform is dependent on the ServiceDate value and I have an event.
My data is coming through just fine.
I would like to know how to click on the service date for the pt and the ProgressNote form reopens to that record for the date that was click.
0
donvike1Author Commented:
I found the solution to the frm_ProgressNote form and DateOfService subform by doing the following:
Click on the DateOfService textbox control on the subform
Click properties - Event - 3 dots
You will see
Private Sub DateOfService_Click()
type the following just above End Sub and just below Private Sub
DoCmd.OpenForm "frm_ProgressNote", , , "[DateOfService]= #" & Me.DateOfService & "#"
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
donvike1Author Commented:
The other comments did not work for me as I did not understand, so I read up on all the events and controls and was able to resolve the issue.
0
donvike1Author Commented:
Correction
I found the solution to the frm_ProgressNote form and DateOfService subform by doing the following:
Right Click on the DateOfService textbox control on the subform
Click properties - Event - 3 dots
You will see
Private Sub DateOfService_Click()
type the following just above End Sub and just below Private Sub
DoCmd.OpenForm "frm_ProgressNote", , , "[DateOfService]= #" & Me.DateOfService & "#"
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.