Calendar Control on a continuous subform

[MOC835]

I have calendar control that I am trying to use on a continuous subform
to select two dates.

My MainForm collects user data, and the continuous SubForm collects two
dates for that specific user...an IssueDate and a ReturnDate.

I am trying to give the user the option of entering the date into the
date field text box, or clicking a button next to the text box to open
a seperate form with a calendar in it (frmCalendar).

My problem is that I can get the form to open without a problem. I
can't seem to get it to pass the value from the calendar back to the
subform which contains the date fields.

Another problem I had was that when It would return the value back to
the subform, it would send it to the first record in the entire
subform, which wasnt for the specific user record that I was working
on.

I hope this is enough info for someone to help!

MOC

[Lyle Fairfield]

"MOC835" <Mo****@gmail.comwrote in news:1166406861.450305.26150
@n67g2000cwd.googlegroups.com:

My problem is that I can get the form to open without a problem. I
can't seem to get it to pass the value from the calendar back to the
subform which contains the date fields.

I hope this is enough info for someone to help!

Sure, that explains everything.

--
Lyle Fairfield

[Ron2006]

Some more information is required..........

How are you opening the calendar form? Are you using a button in the
main form or a double click on the subform.?

You have to be sitting on the record in the subform for either approach
to work, but we need to know more before any clear approaches can be
given.

Ron

[MOC835]

Here is the skinny on my form...it is being used in a school.
I have a main form called 'frmStudentEntry' with a tab that has a
subform under it called 'sfrmAssignDates'.

Here are the fields in each table:

frmStudentEntry
StudentPK
StudentNo.
FirstNameMI
LastName
ASNo.
UserID
Principal

sfrmAssignDates
DatesPK
StudentPK
LockerPK
IssueDate
ReturnDate
The IssueDate and ReturnDate fields are text boxes that have a button
next to each field(on the subform) that the user can click to select a
date from a calendar. When clicking the button, it will open a form
called 'frmCalendarIssue' or 'frmCalendarReturn' depending on which
button is pressed.

My questions are :

(1) How do I use the same calendar for each date field on this form,
and in other forms.

(2) How do I link the Calendar so it will return the selected date to
the subform after closing out of the calendar form.

I hope this helps.

MIKE

mo*@NOSPAM.twcny.rr.com

(remove the NOSPAM)
Ron2006 wrote:

Some more information is required..........

How are you opening the calendar form? Are you using a button in the
main form or a double click on the subform.?

You have to be sitting on the record in the subform for either approach
to work, but we need to know more before any clear approaches can be
given.

Ron

[Lyle Fairfield]

"MOC835" <Mo****@gmail.comwrote in news:1166547969.833159.166930
@t46g2000cwa.googlegroups.com:

Here is the skinny on my form...it is being used in a school.
I have a main form called 'frmStudentEntry' with a tab that has a
subform under it called 'sfrmAssignDates'.

Here are the fields in each table:

frmStudentEntry
StudentPK
StudentNo.
FirstNameMI
LastName
ASNo.
UserID
Principal

sfrmAssignDates
DatesPK
StudentPK
LockerPK
IssueDate
ReturnDate
The IssueDate and ReturnDate fields are text boxes that have a button
next to each field(on the subform) that the user can click to select a
date from a calendar. When clicking the button, it will open a form
called 'frmCalendarIssue' or 'frmCalendarReturn' depending on which
button is pressed.

My questions are :

(1) How do I use the same calendar for each date field on this form,
and in other forms.

(2) How do I link the Calendar so it will return the selected date to
the subform after closing out of the calendar form.

I hope this helps.

MIKE

mo*@NOSPAM.twcny.rr.com

(remove the NOSPAM)

Examining the code in the form modules in
one of the mdbs listed in
http://www.ffdba.com/datepicker.htm
may help.

--
Lyle Fairfield

http://www.ffdba.com/toyota/BurlingtonToyotaLease.htm

(just a sad story - read if bored)

[Ron2006]

I agree, that the datepicker mdb example that Lyle is referencing is a
good example.

I have used that form etc. in a number of applications. In most of my
cases, however, I have initiated the call on the double click of the
field involved instead of a separate button as the sample uses. Both
methods are viable. and easily done.

Ron