DateAdd Function

[jschlapi]

I have a form (Called Entry Form) that includes a date which the user inputs. I would like to duplicate that record - which I've done & it works great - but now I would like to increment the date field by 1 day after the duplication is done.

My date is in a text box (Called Text3957) and my code attached to a control button on the screen is: DataAdd("d",1,Text3957).......it does not work. The only part that works on the button is the Duplicate Record - I end up with the same date on both records.

Any ideas why this is happening? Thank you for your time & advice.

[RuralGuy]

What code do you have in the "DuplicateRecord" button?

[jschlapi]

This is what came with the button command:

run command: SelectRecord
run command: Copy
run command: RecordsGoToNew
run command: SelectRecord
run command: paste
run code: DateAdd("d",1,Text3957) -- THIS IS THE LINE I ADDED

[RuralGuy]

We'll need to copy the previous date and save it somewhere (a variable maybe) before moving to the New record. I'm not versed in the RunCommands, only know code.

[RuralGuy]

It may be something as simple as changing this line:
run code: DateAdd("d",1,Text3957) -- THIS IS THE LINE I ADDED
...to...
run code: Me.Text3957 = DateAdd("d",1,Text3957) '-- THIS IS THE LINE I ADDED