Dynamic Multiple Choice Inputbox

[craigachan]

I would appreciate any help on this inputbox.

I want to fill data on a form with info from a multiple choice input box. The inputbox choices come from an inventory table. The choices for the input box will change as inventory for that particular item change. Example:

TblInventory with records: Item1, Item2, Item3 .... This table changes with use of the stocked Items.

So the inputbox is something like:

Please select item from inventory.
Item1
Item2
Item3
...

The response to the selected item is placed on my form.

Is it possible to have a dynamic inputbox like this?

Thanks for any help.

 

[ajetrumpet]

not it's not. not with the built in box that Access provides. However, you may want to build your own forms, eg. - password notifications, etc...

I do this all the time, where you build "OK/CANCEL" buttons that really just very small forms that look like popup notifications. by this token, you can use whatever controls you want to get what you need done. Example, for what you need, I would think that a form with multiple text boxes on it with accompanying check boxes beside each one as indicators would work just fine.