Member Avatar for Adasha

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!

  • 2 Contributors
  • 1 Reply
  • 82 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Andrew de Beer
Member Avatar for Andrew de Beer

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.