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

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

You would put this in the control's Before Update event:I'm sure Bob meant to say the "Form's BeforeUpdate" event.

Thankyou guys!