Ship to Store or Specify an address

[cscura]

Building a RMA database. The issue I am running into is how do I get store address to auto populate in the shipping address on a form if they check the box for Ship to Store on the same form. This may sound easy but the thing is there are over 5000 different store addresses. I do have a Store number field on my Form that is a child to a Store number table that houses all the store addresses. If someone will help me write this code or have any suggestion on how to make this happen?

[pbaldy]

One way, if you have the various fields in the combo row source (can be hidden):

BaldyWeb - Autofill

[cscura]

Yeah I just figured it out.
I have all the info in the combo box and on my code for my onclick for the Ship to store combo box is:
(code)If chkSAS = True Then txtShipAdd = [StoreIndex].Column(2)
txtShipCity = [StoreIndex].Column(3)
txtShipState = [StoreIndex].Column(4)
End If
If chkSAS = False Then
txtShipAdd = " "
txtShipCity = " "
txtShipState = " "
End If
(/code)
It works very well.

[ranman256]

After update of the STORE,
run an update query to populate the addresses via STOREID key.

[June7]

ranman, why run an UPDATE when the record is already open on the form? - just populate the fields as cscura is doing.

cscura, you are saving the descriptive address text into the record? Why not just save the address ID? Then to just display the address in the textboxes does not require VBA.

[pbaldy]

cscura, you are saving the descriptive address text into the record? Why not just save the address ID? Then to just display the address in the textboxes does not require VBA.

If you want the actual address shipped to saved, you can't just store the ID, as stores can move. Alternative is to store each store address with a different ID, but most just keep a single record for the store and its info.

[June7]

Good point Paul, if don't want the ship to address to be altered in historical records in the event customer changes locations, must save the address info or create new address record, which would probably mean another field for Active/Inactive. Similar conundrum as in product pricing - save price or create new product record.