Calendar input

[Glowackattack]

Hi,
i have a form set up with a subform, and then a subform built into that subform. On the subforms subform, i have a date field that i would like to have pop up a calendar and input a date into that field, are there any examples on how to do this?? I have only seen examples for subforms, not subforms of subforms...

Thanks in advance for your help,

 

[dkinley]

For the examples you looked at ... I would guess it would be a referencing issue. Because of specifics, I am not sure if when you click to call the Calendar if (or how) the click function passes the form and/or control name to the Calendar so when you click a date it passes the date back to the control, or, if you Calendar is a one-off event and not used elsewhere so the reference is hard-coded.

Here is the reference for getting to a second subform from an outside form:

Forms!Mainform!Subform1.Form!Subform2.Form!ControlName

Substitute names as necessary, again, just a guess based on first thoughts.

-dK

 

[Glowackattack]

I see, this is a stupid question probably, but my subform names have spaces in them (i.e., frm_PolicyBreakdown subform), and i think i've had problems with that before, how can i make that so it works?? can i use brackets [] around the full subform name??

 

[dkinley]

Should be able to. If not, something else weird is going on ...

-dK

 

[dkinley]

Speaking of weird ... one thing I ran into before is that what I thought was the subform name really wasn't.

A way to check is to go into the VB editor of the main form of that subform. In the editor type Me. and let the intellisense pop-up and scroll down to see if you see the subform name there.

-dK

 

[Glowackattack]

Beautiful....everything is working perfect now...your code "Forms!Mainform!Subform1.Form!Subform2.Form!ControlName" really helped me...

May i suggest for future reference if anyone else reads this to use it like this instead

Forms![Mainform]![Subform1].Form![Subform2].Form![ControlName] so my code said....

"""Forms!Frm_CaseOverview![Frm_PolicyOverview subform].Form![Frm_PolicyBreakdown subform].Form![Prem Date] = CalObject.Value"""

That just worked for me because the code didnt like the spaces in my subfom name.

Thanks very much for your help!!!

 

[Kiwiman]

FYI

You should check out Uncle Gismo's calendar form - see the link in his first post. Pretty easy to implement, and takes out all the drama of referencing subforms etal. This is all I use now for calendars.

http://www.access-programmers.co.uk/forums/showthread.php?t=148750

 

[Glowackattack]

Thanks Kiwiman, I actually did see that thread when i searched...but my work has the website blocked I'll check it out when i am at home though.

Thanks for the input.

 

[dkinley]

Glad it was only that and nothing else.

-dK