Hi all.
We have a very simple form that our folks use to enter payments into a
table called tblPayments. The table and form fields are CustomerID,
DatePaid, DateDue, and AmountPaid. Very basic.
We want the "default" value in the DateDue field on the form to
display a date exactly 1 month in the future from the DatePaid. This
way when people enter payments, the next due date will be
automatically populated.
We do want the users to be able to override that 1 month ahead Due
Date if they have cir***stances that warrant it.
We have tried setting the default value of the DateDue in the table to
one month ahead by using DateAdd in the Default property and we tried
setting the Default value in the DueDate textbox on the form. Neither
work.
Can what we want even be done? Whats the best way?
Any help you can give is greatly appreciated.
Thanks
GB
