Select data through a calendar - vba access 1

[JoanaSantos]

hi,

so, i have this table:

"T_MES"
date1 date2
31/08/2015 09/09/2015

How can I change the date through a calendar?
I create a form with two textbox.. and in the properties I select this:

PROPERTY
format: shortdate
Show date picker: for dates

so, efverytime I click in the textbox i'm able to select a date through a calendar.
but my question is.. how can I insert the new date in the table "T_MES"?

there is another way to do this?

thanks

 

[dhookom]

If the two text boxes are bound to date1 and date2, the selected dates will be stored in the table. Are you experiencing something different?

Duane
Hook'D on Access
MS Access MVP

 

[JoanaSantos]

how can i bound?

 

[dhookom]

You set the Control Source of the text box to a field in your form's record source.

The form's Record Source must include the table T_MES.


Duane
Hook'D on Access
MS Access MVP

 

[JoanaSantos]

thanks! it's working

 

[Andrzejek]

Please mark any helpful post(s) with a Star.

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.