Duplicate fields

[Chigger Hill]

I am working on a simple database with two addresses. One address for a bill
to address and one address for a protected address. I would like to have
the protected address default to the bill to address unless changed in the
form to eliminate having to enter the address twice. This operaton would be
similiar to the asking of the question use billing address as the ship to
address. I do not work using code so i am limited primarily to the wizards.
Any help would be appreciated.

 

[Tom Wickerath]

If you are willing to start dabbling in VBA code, this is a pretty
straight-forward task to accomplish. An example is shown in the Access 2003
version of the sample Northwind database, on the Orders form
(CustomerID_AfterUpdate procedure).


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________