Default Value Problem on TextBox

[SpiritedAway]

Hi,

I have a datasheet form, on this form are two fields [DateStarted] and [DateEnded].

I want the Default Value of [DateEnded] to be that of [DateStarted] as it is on the next record on the form.

So on ID 1, the [DateEnded] would have the default value of ID 2 [DateStarted]

So that whenever I create a new record the Date for [DateStarted] will update as the default value for [DateEnded] on the previous record.

etc....

Can anyone advise how to achieve this.


I'm using A2007

Thanks!

SpiritedAway

 

[missinglinq]

You're saying that you want the default value of a control to be based on the value of a different control on another record, a record that, in fact, doesn't yet exist!

Is this what you meant to say?