How to pull information from the previous record

[winedott]

Hello again,
Again I am very new to access. I am running access 2007. I am wondering if there is a way to pull data from a previous record and place it in the current record.

For instance: Lets say that 10 customers called in for a service call. I was able to finish 6 of them. On the form I have it calculate the 10 customers minus the 6 I finished which left 4. I want to pull the field of 4 (this is just a number not names) over to the current record so if 10 more customers call it will give me a total of 14.

I hope I didnt confuse anyone. Please let me know if you need any other information.

 

[John Big Booty]

This thread should point you in the right direction.

 

[winedott]

Ok remember I am very new with Access. I reviewed that link and I have placed the following under Control Source under the field that I want the information to be placed.

=DLookUp("[Value1]","tbl1","[IDData]=" & Forms![frm1]![IDData]-1)

I am unsure what needs to be changed to pull the correct information. I changed what I thought to be right but I recieved Name ?

 

[winedott]

Well I answered my own question and figured it out. Thanks for your help.

 

[John Big Booty]

Well I answered my own question and figured it out. Thanks for your help.

Glad you got it working