Using a Labels Caption Programmatically

[ksmith]

Thanks in advance for any help,
I have modified one of Access 2007 INSIDE OUT calendar forms to display some of my data in a Project Tracking Application that I am writing. It displays the Project Name on the calendar form in the Month and Day that the project is due. The form works great. The problem is now The Boss wants to be able to double-click on a Calendar day and display more detailed information about the project that is due on that date. There can be many projects due on the same calendar date. In the calendar form the day of the month is written to a label, and shows up in the labels caption, and the data (if any) is written to a text box. What I am attempting to do is build a variable that has the same property as the calendar DATE that was double-clicked.
For example; If two projects are due 10/22/2010 you would double-click on that date on the calendar form. The code would ultimately filter a query and display those two items, via another form.


The main problem that I am having is getting the VALUE of the LABEL CAPTION into a format that I can use. How do you ‘extract’ a labels caption?
Can anyone think of a better way to do this?

How do you store the extracted information to use in the programs next step?

Thanks,
KSmith

[ajetrumpet]

How do you ‘extract’ a labels caption?

you reference it:

forms(form).controls(labe.).caption

labels don't have values.

I believe the caption returns a string.

[ksmith]

Thanks for the speedy reply. I still can't seem to get it to work.

Thanks Anyway,
KSmith