Using Calendar to select records

[Matthew Ellis]

I am working on a scheduling app (like a beefed up version of Outlook) and
need to have a calendar control select the date to work from. There are
three sub forms that all need to be update by this also. The problem I am
having is that if I use the date from the calendar control as a unique index
(so there are not many different records for one date) It makes it
impossible to go back and add to a date later because it would cause a
conflict in the index.
Any help is appreciated.

 

[David Fournier]

Try using a Date and Auto Number combo as your unique index.