Use Unbound Dropdown to populate Subform

[Guest]

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

 

[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

set the rowsource of the textboxes to

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

 

[Guest]

thank you - Bob

set the rowsource of the textboxes to

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