Pop-Up Calendar On Subform

[Guest]

I have a parent table related one-to-many to it’s child. I built a query
combining some elements of them both which allows me to sort those records
the way I need to. I have a subform based on this query for the data entry.
Two of these data entry fields are date fields. I would like to use a pop-up
calendar to feed dates into these fields from my form, but can’t grasp how to
tie the pop-in date with a new record on the subform. I have used Allen
Brown’s “pop-up†calendar to feed parameter info into report queries and it
works great. If I add an unbound text box and pop-up calendar for each date
field I want to input, and point the criteria for those date fields in the
query to these unbound text boxes, how can I get this input to feed into a
new record, or will this happen automatically? Thank You.

 

[Allen Browne]

Hi Jeff

You can use that calendar in a subform. Display the subform in Continuous
view rather than Datasheet, and you can place a command button beside the
date control (if you want it on every line), or in the Form Header section
(in which case it applies to the current row.)

Alternatively, you could use Datasheet view, and use the DblClick event of
the date field to pop up the calendar.

Either way the process is the same. Since the calender refers directly to
the text box, there is no problem with the reference when the date field is
in a subform (or even a subsubform).

 

[Guest]

Thanks Allan:

I am out of town until next week but I will give that doubleclick event a
try. Your calendar works slick the other places I have used it...I will
change my subform a bit and try your calendar for those other fields.
Thanks again

 

[Guest]

Found this posting and grabbed me a copy of your calendar. Excellent piece of
work, and absolutely easy to use. Thanks a lot.