CHeck Box for Shipping Address

[SoCal]

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!

 

[boblarson]

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.

 

[SoCal]

OK, makes sense. Hadn't thought of it that way.

Can you show me some detail (steps, code, etc.) of how to do #3?

 

[boblarson]

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

 

[SoCal]

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!

 

[SoCal]

Got it figured out. Thanks for the help!

 

[boblarson]

Got it figured out. Thanks for the help!

Sorry I couldn't post back sooner (so glad you figured it out). Been very busy the past several days.

 

[Catalina]

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

Catalina

 

[boblarson]

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

Catalina

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

 

[Catalina]

I missed you, got very worried already.

Catalina