method of having a user enter a table of information

[robojeff]

I am looking for some ideas of a clean way to prompt a user to input one or more values on a form where these items would be placed in a table. Then the user can perform one of a few different queries to pull specific data on the list of items.

I typically use a text box for a single item but what are some "user friendly" ways to have them input more than one or several items?

thanks

 

[jrbarnett]

Form in datasheet view? it looks like a query grid.

You get the power of VBA events to validate data, but a screen that looks like a query.

John