set value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chey - 15 Jan 2008 18:52 GMT

I am not sure if I am doing this right. I am doing mailing and physical
address's. I have a check box for same address. How do I populate the
physical address fields.
My field names are
Physical Address
Physical City
Physical Zip

Thanks

Reply to this Message

Olduke - 15 Jan 2008 19:45 GMT

First question, why are you using checkboxes. Don't worry, I'm not expecting
an anwer its just most people use checkboxes when there are easier way to do
things. Can you not classify your mailing list by a field where you would
enter A, B or C?

Anyway, to get to your question, create a query to do your mailings. Enter
all the fields yoou require including the checkbox field. In the criteria of
the checkbox field enter -1 if you want the unchecked boxes on the list or 0
(zero) if you want the cheched boxes.

> I am not sure if I am doing this right. I am doing mailing and physical
> address's. I have a check box for same address. How do I populate the
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Dale Fye - 15 Jan 2008 22:01 GMT

I think you've misunderstood the OP. I believe what he has is a checkbox
labeled something like: Physical address is the same as Mailing address.

Where a check in the box means he doesn't have to enter date in the Physical
Address text boxes.

Chey:

You should be able to put some code in the checkboxes afterUpdate Event,
something like:

Private Sub chk_SameAddress_AfterUpdate

me.PhysicalAddress = IIF(me.chk_SameAddress, me.MailingAddress, "")
me.PhysicalCity = iif(me.chk_SameAddress, me.MailingCity, "")
me.PhysicalZip = iif(me.chk_SameAddress, me.MailingZip, "")

End Sub

HTH
Dale

Signature

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

> First question, why are you using checkboxes. Don't worry, I'm not expecting
> an anwer its just most people use checkboxes when there are easier way to do
[quoted text clipped - 15 lines]
> >
> > Thanks

Reply to this Message