Populate Listbox with Parameter Query in VBA

[jxt1303]

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.

[puppydogbuddy]

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.

http://allenbrowne.com/ser-51.html