Auto fill in same record

[Guest]

I have a database, Acess 2000, with a table that contains a field for a
mailing address and a field for a physical address. Once I have typed in the
mailing address, I would like Access to automatically fill in the physical
address field so I do not have to type it again. I would also like to be
able to overwrite the physical address if it is different than the mailing
address.

Any help would be appreciated. Thank you.

 

[Joseph Meehan]

I have a database, Acess 2000, with a table that contains a field for
a mailing address and a field for a physical address. Once I have
typed in the mailing address, I would like Access to automatically
fill in the physical address field so I do not have to type it again.
I would also like to be able to overwrite the physical address if it
is different than the mailing address.

Any help would be appreciated. Thank you.

Sure. You will need one form for entering new data and one for editing
data. make sure you restrict each from for data entry only or No data
entry.

Then on an appropriate event like exiting the last field of the mailing
address fields have it copy the data to the physical address field and
refresh the data displayed.

 

[Guest]

Thank you. As an Access "newbie", could you explain how to "have it copy the
data to the physical address field and refresh the data displayed."

 

[Steve Schapel]

Val,

On your form, on the After Update event of the Mailing Address textbox,
put code that looks like this (substituting your own control names, of
course)...

If IsNull(Me.Physical_Address) Then
Me.Physical_Address = Me.Mailing_Address
End If

 

[Guest]

Thank you, Steve. I will give that a try. As this is an at-work database, I
will do it on Monday when I go back to work.