calendar control

B

Ben

Hi all
I have Access202. I am trying to put a calendar control on a form.
I have a table with name SystemDate only a field and only one record, called
sysDate.
I would like to select a date on the control and have it update the
sysDate's value immediate.
But for some reason I am getting a error message:
Control can't be edited; it's bound to unknown field "sysDate"
In fact when I run the form, I can't even click on the controls to change
the date.
I read it's a bound control, I tried setting the Control Source property to
sysDate,
but did not work either. Please sharing some of our thoughts. Thanks in
advance.

Ben


--
 
G

Gijs Beukenoot

From Ben :
Hi all
I have Access202. I am trying to put a calendar control on a form.
I have a table with name SystemDate only a field and only one record, called
sysDate.
I would like to select a date on the control and have it update the
sysDate's value immediate.
But for some reason I am getting a error message:
Control can't be edited; it's bound to unknown field "sysDate"
In fact when I run the form, I can't even click on the controls to change
the date.
I read it's a bound control, I tried setting the Control Source property to
sysDate,
but did not work either. Please sharing some of our thoughts. Thanks in
advance.

Ben
Click to expand...

Is the form bound to the table SystemDate?

Coz it sounds like it isn't...
 
B

Ben

ok, I got it to work, but only after when the form is closed.
I would like it to reflect the date immediately.
Any thoughts? Thanks.

Ben
 
Top