Default value

[Kanter]

How can I set the previous record as data source for default value in MS Access table?

 

[boblarson]

If you are working directly in the tables, you can't. If you are using a form to do data entry (which you SHOULD be using), then you can.

You would put this in the control's Before Update event:

Me.YourControlNameHere.Default = Me.YourControlNameHere

 

[RuralGuy]

You would put this in the control's Before Update event:

I'm sure Bob meant to say the "Form's BeforeUpdate" event.

 

[Kanter]

Thankyou guys!