Calendar linked to form

[Guest]

I'm having trouble with a calendar linked to a form. I have a main form with
three calendar buttons. When clicked a small form with a calendar and a
close button comes up. The main form is NOT closed when the calendar form
opens. I select the date using the calendar and click the Close command
button on the calendar form. The main form should then have the date filled
in to the correct field. What I'm getting is the first record on the main
form changed, not matter what record I'm working on. Is there a way to link
the calendar to the active record? Thanks!

floprock

 

[Guest]

how are you opening the calendar form?
how are you putting the date into the control on the main form?

-Dorian

 

[Guest]

I'm opening the calendar with a macro (openform), and then there is a command
button on the calendar's form to close it (macro - close form).

I just have the text box on the main form with a data source of the query
for the main form. The calendar is also pointed to this same field.

floprock

 

[Bob M via AccessMonster.com]

What calendar form are you using.
I use Datepicker that does what you want and doesn't use the unreliable
ActiveX calendar available in Access.
You can find Datepicker here:
http://www.glump.net/dokuwiki/software/microsoft_access_date_picker
Good luck.

I'm opening the calendar with a macro (openform), and then there is a command
button on the calendar's form to close it (macro - close form).

I just have the text box on the main form with a data source of the query
for the main form. The calendar is also pointed to this same field.

floprock

how are you opening the calendar form?
how are you putting the date into the control on the main form?

[quoted text clipped - 11 lines]

 

[Guest]

I found a site that had a nice little pop-up calendar exampled. Here's the
link: http://www.fontstuff.com/access/acctut09.htm. Thanks for your help!

What calendar form are you using.
I use Datepicker that does what you want and doesn't use the unreliable
ActiveX calendar available in Access.
You can find Datepicker here:
http://www.glump.net/dokuwiki/software/microsoft_access_date_picker
Good luck.

I'm opening the calendar with a macro (openform), and then there is a command
button on the calendar's form to close it (macro - close form).

I just have the text box on the main form with a data source of the query
for the main form. The calendar is also pointed to this same field.

floprock

how are you opening the calendar form?
how are you putting the date into the control on the main form?

[quoted text clipped - 11 lines]

floprock