Hello everyone,
I'm new to this forum and I'm also new to MS access.
Im facing a problem with opening a new form from a form and setting two fields to equal two other fields from the original form.
I have Form A which includes FieldA and FieldB, and FormB which includes FieldC and FieldD.
Now here is the problem, I want to open FormB from FormA using a button and i want FieldA and FieldB to be copied to FieldC and FieldD in that form.
I found a way to copy one field only by using this on on Click command on the button, which is;
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenForm "FormB", , , , , , Me.FieldC
and by using an on Load command on FormB, which is;
If Me.OpenArgs <> "" Then
Me.FieldC = OpenArgs
End If
but i cant seem to be able to copy 2 fields instead of only 1.
Any help would be much appreciated.
I'm new to this forum and I'm also new to MS access.
Im facing a problem with opening a new form from a form and setting two fields to equal two other fields from the original form.
I have Form A which includes FieldA and FieldB, and FormB which includes FieldC and FieldD.
Now here is the problem, I want to open FormB from FormA using a button and i want FieldA and FieldB to be copied to FieldC and FieldD in that form.
I found a way to copy one field only by using this on on Click command on the button, which is;
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenForm "FormB", , , , , , Me.FieldC
and by using an on Load command on FormB, which is;
If Me.OpenArgs <> "" Then
Me.FieldC = OpenArgs
End If
but i cant seem to be able to copy 2 fields instead of only 1.
Any help would be much appreciated.