Entering duplicate data in a form

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.
 
M

Michel Walsh

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top