Entering duplicate data in a form

  • Thread starter Thread starter Les
  • Start date Start date
L

Les

I am entering data into a table using a form. Two of the
fields in the table will have the exact same data. Is
there a way I can fill to table fields through 1 form
field without having to reenter the data and take a
chance on humar error?
Thank you in advance.
 
Hi,


Sure, in the after update event of the first CONTROL, push the new value in
the second control. Do the reverse in the second CONTROL:


in the first control after update event:


If Me.SecondControl <> Me.FirstControl Then
Me.SecondControl = Me.FirstControl
End if



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top