adding records to table, kinda

[Mikelj]

I've been able to use a Calendar control to pass data to 3 text
fields, ie clicking on the calendar writes the day of the week to one
text box, the month and day to another and the year to another. What
I am trying to do is to have a form with this calendar and these 3
text boxes and another text box (memo format) that the user can click
on the calendar and have the 3 date text boxes fill in then enter data
in the memo text box and save all to a table without over writing any
records. How do I add this record and force the next date clicked on
to write in a new record? Sorry if this isn't to clear. The idea is
sort of a diary of sorts where the user can click on the calendar and
type a note, and also be able to scan through the records to see
pervious dates and notes.
If this will take a lot of code, just say "lots of code needed" but it
this is fairly simple and is just a matter of relationships between
tables or subforms, I would appreciate any help I can get.
Thanks. Mikel

 

[storrboy]

First I have to ask why you are saving the date info in three fields?
One date field formatted the way you want would make more sense to me.
Second I wouldn't use the calendar to initiate a new record. What
happens if the wrong date was chosen - how would it be changed without
creating a new record? I might provide a "New Entry" button which
could have as little code as...

DoCmd.GoToRecord , , acNewRec

Additional code for validation and error trapppig can be added if
desired.