Controlling 'Date' entries in a form

[Guest]

I am creating a database to track different savings entries of users. The
users will each be using the database to enter their own savings numbers. A
single savings entry may have several (up to 12) different dates, and savings
amounts. However, each of the dates cannot be before the date that they are
entering in the information (Today's Date).
I have a table that contains the Name of the person, the date (today's date
automated), a description of the type of savings and the following fields:
Name (the buyer's name)
Today's Date (automated)
Description of Savings
Date_1 (this is where they will enter the date that this particular savings
is to be counted)
Savings_1
Date_2
Savings_2
Date_3
Savings_3
Etc...all the way up to Savings_12

If it is a one time savings then they would only enter information for
Date_1 and Savings_1. However, if it is a savings for more than one time then
they will use the remaining fields for those entries. The problem that I am
having is that they cannot enter a Date (in the Date_1, Date_2, etc.. that is
less than or equal to Today's Date. They also must have at least one Date and
Savings number entered.
I have a form created based off of a query that contains all of the fields
in the table. I am using a Tab Control for different parts of their entries.

 

[Guest]

Just put a check in the before update event of each date for date < todays
date.
I'm not sure your table staructure is the best. You should have a separate
table for the dates and savings.

-Dorian

 

[Guest]

thanks, I'll try that!

Just put a check in the before update event of each date for date < todays
date.
I'm not sure your table staructure is the best. You should have a separate
table for the dates and savings.

-Dorian