Access 2010: Adding an input box to a list or combo

GNOVAK
GNOVAK used Ask the Experts™
on
I have a form where the user will select one or more report names and generate the reports.
Each report default title is in a table along with the displayed report name.
I would like to give the user the option of editing the text for each of the reports selected.

Currently I have a list box fed by a query.
Can I somehow add a defaulted text box to each item in the list, or, should I use a combo box and somehow add a text box to every entry (how?).
Or is there some other way to accomplish this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi,

I would add a table with the user ID, the report ID and the report title. Now you can simply use a continous form where each user can select the wanted report by selecting the row of the form and then edit the title for the report.
On this way every user can have an own title for each report and you don't need a listbox or editbox. You can, if you want, add a combobox to faster select the wanted row if you have an extreme number of records (reports), but I guess that's not thecase.

Cheers,

Christian

Author

Commented:
Sounds like the way to go - thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial