Default = Previous Record

[wizcow]

Hi

When I enter tickets on my Invoice Form, I enter the date and ticket number for each in a new line. Many times I haved numerous tickets for the same date.

On my Invoice SubForm I want the date to give me a default value equall to the previous line items date.

How do I make this happen?

Tom

 

[ColinEssex]

I may be wrong here but I think you can use Me.OldValue

Look up "OldValue" in access help.

Hope this helps, apologies if I'm leading you up the garden path on this

Col