Populate listbox VBA Access

Hello,
I need to populate a listbox, based on the result from a parameratized query, which gets its parameter from the ActiveX Calendar control.

So first, I don't know how to execute a parameratized query using VBA. Then also, the Calendar Control doesn't have a click event, so I don't know how to program it to requery everytime they click a different date.

Help!! Thank you.

Follow Post Reply

See this thread to get you started,,,,you should read all the posts contained therein because several different methods are discussed that will accomplish the desired result. The method chosen is a matter of preference.

Databound list box populated with parameterized query?

Regarding your questions on the calendar control......generally, when a date is selected it is saved to the textbox in the immediate proximity of the calendar control......for a detailed explanation of how calendar controls work, download this free calendar control constructed using a native Access form as opposed to an ActiveX Calendar control which is often problematic.

//allenbrowne.com/ser-51.html

reply