each time i load my form for 'paying expenses' i have 3 fields that should populate automatically.

Date Recieved
Date Due
Date Paid

These should all populate to 'today' but have the option for altering.

I was wondering if there's a way to use the defualt field on the text box to default these values, but ONLY if you're adding a new record...

try the default value Date()

HTH

i'll give it a go. thanks.

hope it works for you--let us know!