date picker error 1

[Whooo]

I added the ActiveXCTL dtpicker to a form and as long as it is'nt tied to a control source - a field called workdate, I have no problems with the form.

When I designate the control source and use a command button on the form to add a new record (DoCmd.gotorecord , , acNewRec) it adds the blank record and then when i try to edit i get the error message

"cant set value to null when checkbox=false"
Any suggestions would be appreciated, please be gentle, I'm new to Access. Cogito ergo sum - I think?

 

[LittleSmudge]

Arrr Yes - that one again.

( You are not the first to fall for that problem & you won't be the last. )

There is a checkbox property on the control ( in design view ).
When this is set to False the control will not allow the field it is bound to to be Null.

If you need the field to be Null for a new record, ( rather than setting the field's default value to Date() or some other predetermined value ), then you'll need to set the checkbox property to True.



'ope-that-'elps.

G LS

 

[Whooo]

Thanks for the help, works like a charm.
Regards,
Whooo
Cogito ergo sum - I think?