Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

calculation

Status
Not open for further replies.

TheRiver

IS-IT--Management
Dec 18, 2003
121
GB
Say if I have the following fields in a form

Field1
Field2

Field2 is made up of a calculation that shows no of days.

I want Field1 to be the no of days from Field2 of the previous record.

How can I do this?
 
Hi,

you would probably need to add you own navigation buttons.

If you use the command button wizard and select record navigation, then go to next record:

it will add code like this:

DoCmd.GoToRecord , , acNext

modify this code to do store the value before it goes to the next record, like this:

Dim value as string
value = Field2 (should be name of text box that holds field)
DoCmd.GoToRecord , , acNext
field1 = value


Hope this is what you want
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top