Displaying Subform Combo Without Dropdown

  • Thread starter Thread starter Carl Grainger
  • Start date Start date
C

Carl Grainger

How do you display info from a subform combo without the dropdown
option/arrow?

I need a main form to display related subform combo fields as if they were
text fields. The subform records should be view only, hence I don't need the
drop down arrow boxes of the combos, I just want to display the data. If I
convert the subform combo to a text box, the values default to the combo
column 1 data (id no's) rather than the display data.

If you can suggest a way of displaying related table records, listing the
required display data as if it had all come from text boxes rather than
combo's, please let me know. Any help at all would be appreciated.

Regards cg
 
Carl,

A combo box without it's selector is a textbox without auto-complete.

If you want to display something other than the combo's ID field, change its
BoundColumn property.

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia
 
Carl,

Don't forget, you can always retrieve other combo data using its Columns
collection.
Me.cboMyCombo.Column(2) 'returns the 3rd column

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia
 
Hi Graham, I was holding back from having to change the bound column in case
there was a way of grabbing the subform table data without it's control type
i.e. copy the selected combo field data into a text box.

Many thanks for the tip.
 
Back
Top