Making the stopdate = the selection 4m the calendar

[lynsey2]

i have the calendar that access gives you.
I want to make it so that if you click on a date that date will fill out the stop date text box on the form?
= adhDoCalendar («varPassedDate»)
in the control source of the stopdate txt box work?
prob not but if you can give me a clue

TA again guy's

 

[RichMorrison]

Sounds like the calendar Getz, Litwin, and Gilbert gave you.

Anyway, you can do this

varDate = adhDoCalendar()
If (IsNull(varDate)) Then
Else
Me![txtSomeDate] = varDate
End If

in an event sub on a form.

RichM

 

[lynsey2]

that doesnt do anything??

nothing at all

did i do it wrong i put it in the after update and tried it then the before update the tried it.
im sorry
thanx 4 the suggestion

i got the calendar from the disc that comes with the Access97 developers hanbook!

 

[RichMorrison]

Lynsey,

The code I posted is from an application that uses the Acc97 "ADH" calendar. Looks like the same thing you are using. This code is in an OnClick event sub attached to a command button on various forms I use.

You click the command button, the calendar form opens, you select a date, the calendar closes, you copy the returned value to some textbox on your form.

It works fine here

RichM

 

[lynsey2]

yep got it thanks a million...was just me being my usual daft self...one plus though im going to malta in less than 6 weeks just booked it so i am quite hyper.

thanks again ur a *(star)
lynsey