I'm not knew to access but I'm very green at vba. I've created a database with two: 1 for putting in the initial incident and the other for the follow up comments. In the field for the person getting assigned to the comments on the first form it could be anyone in our company so I don't want to use a table of all our employees. Since it depends on the issue as to who's assigned to help. Is there a way for me to have a combo box that can be an input for people's names AND pull up ones that have already been used: i.e. Jessica Cook and Jason Goff both have had something assigned to them, their names will show up in a drop down menu OR I can enter Rebecca Miller and it will store her name with Jason and Jessica to use later. I'd prefer to do this in vba and not a subform but I'll put just this in a separate table from my main one if need be. I will obviously need to pull the names in queries and reports. Thanks in advance!
-
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.
Combo box for both input and bound list
Excel Facts
Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Similar threads
- Solved
- Question
- Solved
