Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Populate One Subform from Another Subform?

Status
Not open for further replies.

aregan1

Programmer
Feb 12, 2002
46
US
I currently have an Access form (Form1) that contains two subforms. One (SubformA) contains a number of text boxes and comboboxes. The other subform (SubformB)contains the same fields as SubformA, but in datasheet view.

When a user clicks on a row of data in SubformB's datasheet, I want to populate the controls in SubformA with this data.

How do I do this? How do I refer to the controls, and where do I put the code?

Thanks for you help...

- Anita
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top