How to link a List created from a table to a lable or textbox 1

[Triacona]

Dear All,

Thanks for a great forum!!

I have a form which has a list (ListCp).
ListCp gets its values from a table called
tblReportsAvailable. with the following fields.

Query Name
ctlComment
PageName
Action
SortOrder
Report Name
PrintEnable
PreviewEnable
ExportEnable
ExportTemplate
GenericEnable
GenericFormName
GenericCaption

ListCp uses Query Name as its values.
ctlComment is a field I want to use in a textbox/lable.
I have achieved it with a combobox and list.
But these are not ideal especially the list, and the combo box has a drop down.
Is there a way to use the textbox/Label in VB?

Any help would be greatly appreciated.
Thank you!




Thank you,

Kind regards

Triacona

 

[Triacona]

That's brilliant MajP!!
You can do 0 by 0 hehe!
It seems Access has a long winded way of dealing with subform controls...
I should have stuck with an on form input box!

Thanks again!

Thank you,

Kind regards

Triacona