I am trying to format a form in Access 2003 where users could check off a box and have the home address (already enetered on another subform) auto-filled in the fields that follow. Conversely, if the box is unchecked, users can type the correct address into the fields that follow. I am very new to Access so I need to be "babied" through this. Thanks!
Adasha
0
Newbie Poster
Andrew de Beer
0
Newbie Poster
I am trying to format a form in Access 2003 where users could check off a box and have the home address (already enetered on another subform) auto-filled in the fields that follow. Conversely, if the box is unchecked, users can type the correct address into the fields that follow. I am very new to Access so I need to be "babied" through this. Thanks!
In the Control Source field of each textbox enter [=iif([CheckboxName] = True,Me!subformname![ControlName],null)]
Andrew
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.