I have a subform that includes StartDate and EndDate. In this subform I want the EndDate to be automatically calculated when I enter the StartDate. I understand an update query will do this and I have made one with the following code,

DateAdd("d",21,[StartDate])

How do I go about connecting this to the EndDate in my subform?
Help much Appreciated .

Try this code for the <AfterUpdate> event procedure for [StartDate]:

Me!EndDate = Me!StartDate + 21

___________

If both of these fields are bound to a table then you shouldn't have to use an update query to accomplish what you want....

Hope this helps...

Mitch

Cheers Mitch_____W!