Field help-automatic fill in?

[EjS]

Hi,
I have a table and for a specific reason, a field is repeated. Is there a way for Access to automatically fill in the second field when the information is typed into the first field? A rule in the design table maybe? So the user doesn't have to type it twice. Thanks for the help!

 

[cogent1]

There is no reason I can see why you should have to put the same data twice into one table. But assuming that you do actually have some obscure reason to do so, you would at least be using a form to update the table.

So on the After Update event of your "First field" on the form put this code:

Me!MySecondFieldName=Me!MyFirstFieldName

substituting your own field names of course. Lock the second field to prevent accidental overwriting of the repeated data

 

[EjS]

Thanks. I know putting the data twice is crazy...
The form I'm using is a data access page. I don't see the After update event anywhere on the properties there. Do you know where I would put the code for the access page??