set value

[Chey]

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

 

[Olduke]

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.

 

[Dale Fye]

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
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.