refer to a control on another form in access as a control source

[theBruceGuy]

I sometimes use a pop up calendar for filling in dates on forms and normally
refer to the controlsource like:
calendar control source = "control source name"

This time as I have numerous date fields, I am poping up a form with the
calendar control on it and need to have a name of the control from the
original form.

I have tried calendar control source = "Forms!formname!controlname" and
numerous other variations. Nothing works. How do I do this.

 

[swas]

Check out:

http://www.mvps.org/access/forms/frm0031.htm

I reckon this is a pretty comprehensive answer.

You need "Forms!formname.form!controlname"


Regards

swas

 

[theBruceGuy]

Thanks for the reply, I have tried it and am still having the same error
(424) I have code on the on got focus of field ctccDevReqDate on form frmRFC
to open the form frmPopUpCalendar. My next line of code says:
frmPopUpCalendar!RFCPopUpCalendar.control Source =
"Forms!frmRFC.form!ctccDevReqDate"

Still no success. Any other ideas?

 

[Ron2006]

I use Mr Kidwell's excellent Datepicker, which I got from Dev
Ashish's site, http://www.mvps.org/access/

the specific page is http://www.mvps.org/access/forms/frm0057.htm

and that points to download
http://www.mvps.org/access/downloads/datepicker.zip


it's great and can show you how he handles it.

Ron.

 

[swas]

As best I can see you are still missing parts, ie:

frmPopUpCalendar!RFCPopUpCalendar.control Source =
"Forms!frmRFC.form!ctccDevReqDate"

Should be:

F O R M S ! frmPopUpCalendar . F O R M !RFCPopUpCalendar.control Source =
"Forms!frmRFC.form!ctccDevReqDate"

Spaces added to note changes only...

Or use the control Ron suggested.

swas

 

[theBruceGuy]

Thanks for the links. I followed the instructions and it works great. Better
than the built in Calendar control I was using.

 

[theBruceGuy]

Thanks Swas, it got me closer, in that the error message didn't appear. It
wouldn't update the field though as it couldn't recognise it. I switched to
the datepicker recommended by Ron2006 and everything is going great now.

Thanks for the help guys.

 

[Ron2006]

No problem.

Glad we could help.

Ron