Displaying Subform Combo Without Dropdown

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
 
G

Graham R Seach

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
 
G

Graham R Seach

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
 
C

Carl Grainger

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.
 

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