List Box Filter

[mikejames]

Good afternoon Great ones!
And happy Labor Day to you all!

I have a list box that lists scheduled appointments. I am hoping to add a date picker at the top, choose a date and only see those appointments for that chosen date.
Thank you in advance for your help.



Mike

[RuralGuy]

If you would be satisfied with *only* showing appointments for a single day, you could start by creating the date control and then reference that control in the RowSource of the ListBox. You'll want to initialize the date in the Load Event of the form.

[mikejames]

Thank you Sir. Would you, by chance, be willing to help me do that?
I'm not sure how to make it happen.
I am completely satisfied if it only shows appointments for a single day.

Respectfully-

Mike

If you would be satisfied with *only* showing appointments for a single day, you could start by creating the date control and then reference that control in the RowSource of the ListBox. You'll want to initialize the date in the Load Event of the form.

[RuralGuy]

Sure. Have you created the date control yet?

[mikejames]

Negative sir. Would I create a text box formatted with Date? Then perhaps add the code in the After Update control?

Sure. Have you created the date control yet?

[RuralGuy]

Pretty much. Just create the TextBox first and test the ability to change it.

[mikejames]

Ok. I will attempt it now. Can you help with what specifically I would enter in the After Update control?

[RuralGuy]

Sure but get the control working first. Then we'll initialize it in the Load event of the form.

[RuralGuy]

OK, create the date control on the form so it looks the way you want and then send it to me zipped up. The poster has supplied me with a copy of the db so we can speed up the process some for those following along.

[RuralGuy]

Hmm...did you plan to use one of the two controls already on the form?

[mikejames]

I'm sorry to which controls are you referring?

[RuralGuy]

It looks like they are SubForm controls. I need to examine them closer for function.

[RuralGuy]

Okay, they are just to show the counts of your records. Let's take this off line for a bit to clear up some of the functions. Without the db, anyone reading this will just be lost.

[mikejames]

Agreed. Okay.