Pick a record to populate a form

[Parkroyal]

I have a contacts db with 2 address tables and a table that lists towns& counties in it.

HomeAddress (tbl) related to Contacts (tbl)
BusAddress (tbl) related to Contacts (tbl)
TownCounty (tbl) related to HomeAddress & BusAddress

All the information for these three tables is displayed on a form.

I would like to create a way of picking one of the displayed addresses as a billing address but the billing address is not always one of these 2 addresses so I also need a way of entering new address for billing.

Any ideas for the best way to achieve this?

 

[SteveR77]

Parkroyal,

You could add a checkbox to the form that would be a Billing Address same as option.

When the checkbox is checked in the after update event
you could set the shipping address.

Me.billaddress = Me.HomeAddress
Me.billstate = Me.HomeState

etc.

So when the check box is not checked the billing address information can be entered.

HTH,

Steve

 

[Parkroyal]

Ok Steve

Thanks for that.

yes I suppose I could use a series of check bokes to pick address -- hadn't thought of that -- too obvious.

The different addresses are displayed on different tab sheets on the main display form so if I put a check box as you suggested on the relevant tab sheets they could be checked accordingly as someone is entering a record --- Hmmm

Could I then use an IF statement to demand a entry of the person inputing information if niether check box is ticked?

That way if no billing address I could force a form for inputing the information.

What do you think?

cheers