Continuous Form Carry Over

[Jrzy3]

On the current form I have the Before Update set to the following code:

Private Sub ControlName_BeforeUpdate(Cancel As Integer)
Me.ControlName.DefaultValue = "'" & ControlName& "'"
End Sub

This works great; however, is there way to change this...



Example:

Label1 Label2 Label 3 Label4
Record 1: Control1 Control2 Control3 Control4
Record 2: Control1 Control2 Control3 Control4


Once I enter data in Record 1 Control2 and move to Control3...Control2 of record 2 is automatically filled with same data as Record 1 Control2

Is there a way to prevent this occurrence until I actually move to Record 2?

[Dal Jeanis]

1) Access is doing exactly what you told it to do, when you set the default value.

2) It shouldn't affect Record 2 at all if Record 2 actually exists with data, and it shouldn't affect your data entry if Record 2 does not exist with data.

So, what's making you think this behavior needs to change?

[Jrzy3]

I am good with it, but there are going to be about eight different users entering data...didn't want them to think or possibly doing something wrong. So I was wondering if there was a way for record 2 to populate once the user clicks on the first control within record 2. I guess more of a presentation for less confusion...if that makes sense...