Calendar

Blanic

Registered User.
Local time
Today, 16:40
Joined
Jul 8, 2001
Messages
11
I am needing some code for a calendar in Active X. I have created a calendar and a bound field called date. I have made so that when I click a date on the calendar it also shows up/changes in the bound field of date. I also have a subform that is bound to date so that I can add times and names. How do I add a new record when I click on a date? Right now when I do, if I click on a different date, my subform dates change to the date I clicked. I want it to recognize when data is in the field so that it doesnt change it, but if there is no data in the name or time of the subform, it adds the new record. Right now it adds the new record, kinda, but for it to keep the current date in the subform, I have to physically go to a new record.
Thanks
Andy
 
Just put DoCmd.GoToRecord , "", acNewRec in the OnOpen event for the subform.
 

Users who are viewing this thread

Back
Top Bottom