Display drop-down on form to allow user input

[dhstein]

I want to display a form to the user. The form will show expected quantity
of items received from a vendor. I want to provide a drop down column in the
form that will allow the user to pick a number from 0 - N (where N is the
number expected) which is the actual number of items received. I can create
the drop down box using the lookup wizard but only with a constant value of N
like 20 for example. So if there were only 10 items expected, I'd like the
drop down to display only values from 0 - 10. Any help is appreciated.

 

[dhstein]

Steve,

Thanks for your response. I wasn't clear enough in my question. I want a
form that's a datasheet view that lists each item that's being received in
column 1 and the expected qty in column 2. In column 3 I want a dropdown
that will display numbers from 1 to N where N is the value in column 2.

First, you need a table of 0 to N. Then you need a query based on this
table. Set the criteria for the number field in this query to:
<=[Expected Number]
[Expected Number] needs to be a field on your form. It can be a bound field
or unbound field.

Finally, you can use a combobox or listbox to select the quantity of items
received. Whichever you use, set the rowsoutce to the query.

Steve
(e-mail address removed)

I want to display a form to the user. The form will show expected quantity
of items received from a vendor. I want to provide a drop down column in
the
form that will allow the user to pick a number from 0 - N (where N is the
number expected) which is the actual number of items received. I can
create
the drop down box using the lookup wizard but only with a constant value
of N
like 20 for example. So if there were only 10 items expected, I'd like
the
drop down to display only values from 0 - 10. Any help is appreciated.

 

[Bob Quintal]

I want to display a form to the user. The form will show expected
quantity of items received from a vendor. I want to provide a
drop down column in the form that will allow the user to pick a
number from 0 - N (where N is the number expected) which is the
actual number of items received. I can create the drop down box
using the lookup wizard but only with a constant value of N like
20 for example. So if there were only 10 items expected, I'd like
the drop down to display only values from 0 - 10. Any help is
appreciated.

Some things to think about:

How will you handle an overshipment?

Do you expect your users to scroll through 999 rows in a bombobox next
time they receive 1000 nails?

The time taken to dropdown a combobox, scroll to number 23 and click on
the next field of the form is longer than typing 23{enter} on the
keypad.