Hey everyone,
This question may be hard or it may be easy, I am not quite sure. I will try to explain it as simple as possible but it may be kinda long. Well here it goes:
I have a form acting as a calendar that is able to automatically fill in the current month along in a textbox at the top and all of its dates, each as its own textbox below. (See Attached Screenshot) Within each date box, I have a list box that is able to look up data in a query and come back with the events that are on that specific day. (See Date 6/6/2009 in Screenshot)
The problem I am having is, each list box has its own query to look up the specific date in its box, which leaves me with 41 different queries to run for the month and this slows down the form quite a bit and is pretty heavy on the CPU. Is there any way to have one query that pulls back information depending on what listbox is calling the information?
For instance, right now my query criteria is [Forms]![frmEventCalendar]![D1], where D1 is the name of the specific list box. Is there a code that can replace D1 with the name of whatever calls the query?
Thanks ahead of time!
Jason