Retaining Data in Next form entry

[Darth_Elicious]

Hello all,

I have an issue that I thought I had solved in an Access Form, but it isn't working like I need. I have certain fields in the form that are the same throughout the report (or only change once or twice) and I would like for those Text Fields to carry over to the next form dataset when I Add the Resources. I have tried the Carryover command but can't seem to get that to work, the best I have managed is to use this:

Private Sub ProjectID_BeforeUpdate(Cancel As Integer)
Me.ProjectID.DefaultValue = """" & ProjectID.Value & """"
End Sub



However, this is very finicky and doesn't save into the database table when I add the resource. Basically I would like it to do the Ctrl + ' command automatically. Anyone know the coding I would need to carry the data over and add it to the data table when I save the resource data?

Thanks!

[orange]

Review TempVars.

[Darth_Elicious]

Thanks, I will see if this helps me with what I need.