Retrieve Previous Record's Date (1 Viewer)

C

ccflyer

Registered User.

Local time

Yesterday, 22:12

Joined

Aug 12, 2005

Messages

90

• Jun 14, 2006

• #1

Hi everyone,

I have a form with a date field on it. I would like the date field to automatically enter today's date, which it does now, but also I would like it to retrieve the previous record's date and if it is different from today's date, I want the form to use the previous date as the default value.

Does anyone know of how I would go about this?

Thanks,
Chris

 

RuralGuy

AWF VIP

Local time

Yesterday, 22:12

Joined

Jul 2, 2005

Messages

13,826

• Jun 14, 2006

• #2

Referring to a Field in the Previous Record or Next Record

 

C

ccflyer

Registered User.

Local time

Yesterday, 22:12

Joined

Aug 12, 2005

Messages

90

• Jun 14, 2006

• #3

Hey thanks for the link! I can get it to work on old records, but when my form is open and I am on a new record, it doesn't work because the autonumber ID field has not yet been generated. Any suggestions?

-Chris

 

RuralGuy

AWF VIP

Local time

Yesterday, 22:12

Joined

Jul 2, 2005

Messages

13,826

• Jun 14, 2006

• #4

Maybe this link will suggest an approach. How to fill record with data from previous record automatically in Access 2000

 

C

ccflyer

Registered User.

Local time

Yesterday, 22:12

Joined

Aug 12, 2005

Messages

90

• Jun 14, 2006

• #5

Cool, that did work. Thanks RuralGuy!

-Chris

 

RuralGuy

AWF VIP

Local time

Yesterday, 22:12

Joined

Jul 2, 2005

Messages

13,826

• Jun 14, 2006

• #6

Glad to help.