Replicate 2 fields (1 Viewer)

Could I please receive assistance on how, when we click the Replicate Button on the Data Base Form copy and replace any data into the two fields as below?

Copy from WebDate to WebDate_Previous
Copy from Advice to Advice_Previous

Could the click of the Replicate Button, place To-Day’s Date into the WebDate field?

The DataBase that we are using is MsAccess 2003

Thank you for your suggestions

Crystal

access2010 said:

Could I please receive assistance on how, when we click the Replicate Button on the Data Base Form copy and replace any data into the two fields as below?

Copy from WebDate to WebDate_Previous
Copy from Advice to Advice_Previous

Could the click of the Replicate Button, place To-Day’s Date into the WebDate field?

The DataBase that we are using is MsAccess 2003

Thank you for your suggestions

Crystal

Click to expand...

Try this:

98% = essaytee

Thank you for your suggestion which WORKS on the main form, but is not copying the Advice Field Data in the SubForm.
===
Private Sub Replicator_Click()
' == Button Name
Dim lngCurrent As Long
Dim rs As DAO.Recordset
On Error GoTo ErrHandler
Set rs = Me.RecordsetClone
lngCurrent = Me.CurrentRecord
rs.MoveFirst
rs.Move lngCurrent - 2
Me.WebDate_Previous = Me.WebDate
' == Copy to [WebDate_Previous] From [WebDate] and Overwrite Any Data == Main Form
Me.Advice_Previous = Me.Advice
' == Copy to [Advice_Previous] From [Advice] and Overwrite Any Data == Sub Form
ErrHandler:
rs.Close
Set rs = Nothing
End Sub

===
Can you please offer a suggestion on how to copy the data on the Sub Form?
Thank you
Nicole

Create an Update Query as follows:
I named it qry_UpdateAdvice

The click event in full is as follows: