CHeck Box for Shipping Address

SoCal

Registered User.
Local time
Today, 08:30
Joined
Nov 7, 2012
Messages
16
Hi there,

I have a DB with the Customer address in the Contacts Table, and a product shipping address in the Order Table. I have added the shipping address fields to my form, and would like to put a check box that automatically populates the shipping address fields with the Customer address information (from the Customer's table), if they are the same.

Thanks for any help!
 
1. You shouldn't store that information. You should only store the checkbox value.

2. Then when needed, in a query, you can grab that info from the first field if the checkbox value is checked.

3. But in reality you could just have it so that the shipping address is filled in when it is different and then in a query just substitute the main address if the shipping address is null.
 
OK, makes sense. Hadn't thought of it that way.

Can you show me some detail (steps, code, etc.) of how to do #3?
 
OK, makes sense. Hadn't thought of it that way.

Can you show me some detail (steps, code, etc.) of how to do #3?
No "code" really needed. Just an Expression in your query. Sort of like this:

Select FieldName1, FieldName2, FieldName3, IIf([FieldName4] Is Null, [FieldName3], [FieldName4]) As ShippingAddress
From TableNameHere
 
No "code" really needed. Just an Expression in your query. Sort of like this:

Select FieldName1, FieldName2, FieldName3, IIf([FieldName4] Is Null, [FieldName3], [FieldName4]) As ShippingAddress
From TableNameHere

I think I understand the concept, but am not sure how and where to put this expression. I have my query built with the CustomerID, Address1, Address2, City, State, Zip, OrderID, Shipping Address1, Shipping Address2, ShippingCity, Shipping State, and ShippingZIP fields.

How would my Iif function look (specifically), and where does it go? In the Criteria space? Under which collumn?

Thanks!
 
Got it figured out. Thanks for the help!
 
Then stop working so hard Bob, we need you here! :)

Catalina
 
Then stop working so hard Bob, we need you here! :)

Catalina

roflmao.gif
Bet nobody really noticed, except maybe those who I had been helping.
roflmao.gif
 

Users who are viewing this thread

Back
Top Bottom