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

set the rowsource of the textboxes to

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top