G
Guest
Good Day All..
I have an issue that I had posted previously but it did not get resolved.
It may partially be my fault for not explaining my need/question correctly.
I have a form. The form contains a subform. & a tab control.
The subform has 3 fields listed for the user: ShipTo, BillTo & Account Name
The tab control has 3 tabs. The first tab is where I am struggling right
now.
I want the user to select ('click') on the "account" in the subform (data
sheet) at the top. Once they click the "account" the fields on the tab
control will then fill with the data for that specific "account". (Contact,
Address 1, Address 2, City, State, Zip, etc.)
I am not sure what I am missing from a VBA code to make it happen. In the
past I have had forms that passed an "ID" but those opened a form instead of
sending the data to the fields of the tab control.
Does this make sense?
Thanks,
Jim
I have an issue that I had posted previously but it did not get resolved.
It may partially be my fault for not explaining my need/question correctly.
I have a form. The form contains a subform. & a tab control.
The subform has 3 fields listed for the user: ShipTo, BillTo & Account Name
The tab control has 3 tabs. The first tab is where I am struggling right
now.
I want the user to select ('click') on the "account" in the subform (data
sheet) at the top. Once they click the "account" the fields on the tab
control will then fill with the data for that specific "account". (Contact,
Address 1, Address 2, City, State, Zip, etc.)
I am not sure what I am missing from a VBA code to make it happen. In the
past I have had forms that passed an "ID" but those opened a form instead of
sending the data to the fields of the tab control.
Does this make sense?
Thanks,
Jim