input list

[JimTheProgrammer]

I know I'm overlooking something simple, but what contol do I use so the user can input a list of values? Namely, to input a list of employee numbers on a form for use in a query. I know how to use text boxes, and list boxes (to choose from a predefined set of data) but not an empty list box.

 

[jebry]

Hi!

Probably the most intuitional way for your users would be to use a text box and set its EnterKey Function to New Line (on the Other tab in the properties box). Then the user can put in one number then hit enter etc. Alternatively, you can teach them to add a delimiting character(probably a space or a semi-colon). However you do it your code will then need to look for the delimiting character and parse out the numbers for use. If you need help with a parsing function let me know.

hth Jeff Bridgham
bridgham@purdue.edu

 

[JimTheProgrammer]

Thanks for the help. Actually I found the best answer to be a subform. It being a datasheet from of a table. The user can then fill in the table from my form and use it in subsequent queries.