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

Val wrote:
> 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.

--
Joseph Meehan

Dia duit

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

--
Val


"Joseph Meehan" wrote:

> Val wrote:
> > 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.
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>

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

--
Steve Schapel, Microsoft Access MVP

Val wrote:
> 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.

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


"Steve Schapel" wrote:

> 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
>
> --
> Steve Schapel, Microsoft Access MVP
>
> Val wrote:
> > 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.
>