Can you have a form for data input be able to have multiple records on it? For example I have a table that has a category field and in that field is a dropdown box with multiple choices. Is it possible on my form to have an entry for each category type in my dropdown box?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Multiple records input on form
- Thread starter pastorkc
- Start date
Hi Pastorkc,
This can be achieved by utilizing userforms. This may seem daunting at first, but once you play around with the examples in the link below, it becomes easier. This is how I learned to use Userforms. Check the link out below and give it a try.
Userform in Excel VBA
This chapter teaches you how to create an Excel VBA Userform.
www.excel-easy.com
Cheers!
Upvote
0
This is an Access question methinks. Userforms would not apply in that case.
The form would need to be based on a query that returns records that have any of those values in your table field combo list. I imagine it could be hard coded into such a query using IN operator - as in IN(value1,value2,value3) for example, except that you likely won't even know what those real values are, because they're not what you see (as per item 1 in the linked web page). Many/most experienced developers would not use a lookup field in a table (including me).
The form would need to be based on a query that returns records that have any of those values in your table field combo list. I imagine it could be hard coded into such a query using IN operator - as in IN(value1,value2,value3) for example, except that you likely won't even know what those real values are, because they're not what you see (as per item 1 in the linked web page). Many/most experienced developers would not use a lookup field in a table (including me).
Upvote
0
Similar threads
- Question
