Thread: check box help?
View Single Post
  #2 (permalink)  
Old February 27th, 2008, 09:47 AM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

You would use the Before Update and Before Insert events of the data entry form. Then check for a value in the check box, and if it = -1, then do this:

Me.Address1 = Me.BillingAddress1
Me.Address2 = Me.BillingAddress2
Me.City = Me.BillingCity
etc.

Did that help?

mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote