Using the calender object within a form to fill a table with a date

[Otto van der Laan]

Hello,

I'am new in using VBA en encountered a problem using a calender object
within a form in access to fill a date field in a table.

(i made a simular procedure in Word 2003 an it worked fine)

When i use the on_click procedure i receive a null value error, or i
doesn't fill the date field in the table or on screen, or it return a
1899 year value in the date field.
I tried several solution but without success. i uesed variables etc
etc.

Can anyone help me with this?

 

[Harry]

Hi

Just a quick question if you are refering to the onclick on your user form
then this i have never used if you use the on click on the activex object
callender then this should work fine.

two line you can try indevidualy

inside the on click of the ActiveX Callender Control
1) txtText1 = actxCallender1

2) txtText1.setfocus
txtText1.Text = actxCallender1.value