Use Unbound Dropdown to populate Subform

B

Bob Barnes

Would like to populate several fields in a Subform w/ Equipment data in an
Unbound Dropdown..this would be for types of Equipment not yet in the Table
used as the recordsource for the Subform. Existing Equipment in the Subform
could be selected from a Subform Dropdown and populated.

How would I code for a NewRecord in the Subform..and once there, I should be
able to populate the Subform Fields from the Dropdown's .Column(x)....

TIA - Bob
 
P

pietlinden

Would like to populate several fields in a Subform w/ Equipment data in an
Unbound Dropdown..this would be for types of Equipment not yet in the Table
used as the recordsource for the Subform. Existing Equipment in the Subform
could be selected from a Subform Dropdown and populated.

How would I code for a NewRecord in the Subform..and once there, I should be
able to populate the Subform Fields from the Dropdown's .Column(x)....

TIA - Bob
Click to expand...

set the rowsource of the textboxes to

me.MyCombo.Column(X)
Column indices are zero-based, so column(0) is the left-most column .
 
Top