Multi column select with one column for entry

[ericksoda]

I have an application where I display a multiselect list box. That is fine, but now the user needs an additional field in the list box where they can type a number. The list box is variable in length, depending on the specific database it is run for.

For example, the list box might be:

Patient |______________|
Guarantor |______________|
Insurance |______________|

The user needs to select one or more of the lines and enter a value for the next step in the computation. The list could be from 3 to 20 lines long.

Is a combo box the right approach? Or should I use some sort of data grid?

Thanks!

David Erickson

 

[JeremyNYC]

No can do with either a combo box or a listbox, or a subform even.

I would say, stick with the listbox and have a button on your form that users will click once they've selected the appropriate items. The code behind that button will open either an input box or, if you need more control than that allows, a little form of your own, which will collect the data needed. Then it will do whatever you need it to do with that data.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.