Active control Name

[Luis]

Hello.
I have a form with several text boxes. What i'm trying o
do is when i double click on a textbox a form with the
calendar control opens. Then the user chooses a date and
clicks OK. Then the Form with the calendar closes and the
chosen date will be place on the textbox the users has
double clicked. Since i have several text boxes i'm trying
to get the name of the textbox i've double clicked and
then i put the value with the command Forms!
MyForm.Controls!MyControl.value=date_chosen.
Can i replace MyControl with a variable (for example) that
has the contrl name?

 

[Malcolm Cook]

Luis,

I would consider using the double click even of each of the text boxes.

They will look like:

Private Sub myfirsttextbox_DblClick(Cancel As Integer)

myfirsttextbox = Call YourDisplayCalendarProcHere

End Sub

Good luck

 

[Luis]

Ok, i'm trying to use this event on each text box but i'm
still doesn't manage to do that.
When you say
"myfirsttextbox = Call YourDisplayCalendarProcHere"
The "YourDisplayCalendarProcHere" only opens the calendar?
And how can i get the chosen date from the calendar?

 

[MikeB]

This example database in AC2000 format has several examples to demonstrate this behavior.

www.byerley.net/AccessCalDemo.Zip.

works on form, subform and datasheet...

 

[Luis]

I've done it!

Thank you all.

-----Original Message-----
Ok, i'm trying to use this event on each text box but i'm
still doesn't manage to do that.
When you say
"myfirsttextbox = Call YourDisplayCalendarProcHere"
The "YourDisplayCalendarProcHere" only opens the calendar?
And how can i get the chosen date from the calendar?



.