Jan 28, 2004 #1 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?
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?
Jan 28, 2004 #2 Nowell IS-IT--Management Jan 2, 2003 245 GB 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 Upvote 0 Downvote
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