How to use calendar

[Guest]

Hi
I have a form with a text field
i have make it so on click i open another form
where i have a calendar, how can i by click on a date
set the value of the textfield = calendar value , or is tehre another way
to use calendar in a field on a form

Regards
alvin

 

[Guest]

Hi,
what sort of calendar are you using? Are you using an active x solution e.g.
the Date/Time picker that ships with Access or are you using a non active x,
custom approach?
The control which should hold the date/time value should not be bound to a
text datatype field. It should be a date/time datatype field. If you are
using the date/time picker active x control then you can use its on click
event to assign the value that was selected to your control e.g.:

Me.YourDateControl = Me.YourCalendarControl

If you are using a custom approach with a seperate form then just reference
the value, too on some event. To reference another form's control try:

Me.YourDateControl = Forms!YourForm.YourCalendarControl

HTH
Good luck