Calender Control and date field

[KingRudeDog]

Using Access 03....

I know this seems noobish. But I've never used the calender before now. So while I know how to make one...

I created a form with a calender on it [frmCalender].

I placed a command button on my parent form, next to the date field [request_date] to open the [frmCalender]

How do I link whatever date I click on (in the calender) to appear in the [request_date] field?

 

[adaniele]

king,
when you call the calendar form write the following:

Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "frmCalendar"
    DoCmd.OpenForm "frmCalendar", , , , , acDialog, Me.name & ";<your date field>"

then, in your calendar form write:

    Forms(strForm).Controls(strControl) = Me.ctlCalendar.Value

    DoCmd.Close acForm, Me.name

this will assigne the value selected in your frmcalendar when it returns to the previous form (me.name).

i forgot about the module.......here is an example.

i hope this hlp. max.