I have created a Command Button that is designed to give the user the choice of populating fields with some information obtained above it in the current record of a form.
Private Sub Command96_Click()
Me.[FTPUADDR] = Forms![Connector_Form]![FTPUGOOG]
Me.[RTDSADDR] = Forms![Connector_Form]![FTPUGOOG]
End Sub
This successfully updates the fields I want, but then when I open a new record, that information is still in those fields and if I delete or change them in the new record, the previous one changes also. I can not seperate the record entries. I want this command button to only work on the current record within the form.
Thank you for your help
-Chris