Log in

View Full Version : Need Personal Address Information to auto fill Business Address information



Sheffered
02-08-2012, 12:43 PM
Hello, I'm am very new to VBA in Access. I have a tabbed form where the first tab is for the client's individual information and the second tab has their business information. My question is fairly simple: There is a check box called "Same as Address" under the Business Information tab. When I check this check box I want the client's Address from his or her Personal Information tab to auto fill the Address in the Business Information tab.

I have been playing with this code using AfterUpdate on the form:

Private Sub HomeBusiness_AfterUpdate()
If [HomeBusiness] = True Then
[Address].Value = [HomeAddress].[tblIndiv]
End If
End Sub

[HomeAddress] being the Address line from the tblIndiv table where we keep the individual information.

I know I am doing this wrong and have no idea what I am supposed to do. If anyone can help it would be greatly appreciated!

Thank you!