error occurred in a call to the Windows Date and Time Picker contr

[GolfGal]

I'm getting this error and not sure what it means. I have 4 different
date/time picker controls on my form. The control source for several other
fields are based on the result of the date/time picker.

e.g. Anniv is based on DatePicker result + 1 year, etc. etc.

I have used check box as it is possible that 2 of the 4 date pickers will
not be used in some of the records.

Can someone head me in the right direction.

 

[SacCourt]

I think your DatePicker is not a visual basic code funciton, but in fact a
collection of controls or macros that allow your user to pick specific dates.
Dates are numbers so 30 days from today is Date() + 30.

Next year can be harder, leat year and all that stuff. Date + 366, Not
perfect.

For example

30 = Date() + 30
60 = Date() + 60
90 = Date() + 90

I think check boxes would make lousy controls for this type of thing. I
would look firest to a field 30, 60, 90 or 365. Depending on your terms make
decisions. Check boxes will become a headache when the minuete you decide to
put in 2 additional dates to pick. Like Holiday Promotion 180 no interest, 5%
discount if payd in 10 days.

In the field you simply like the terms to a table and a combo box. Adding
new terms happens when you add them to the new terms table.

Forgive me, if I did not completely understand the question.