Question
Thread display: Collapse - |
All Answers
Share your knowledge
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
access 2007 - combo box + multiple records?
I have an access database that displays the users and equipment in my office and which equipment is used by which user. I have a user and equipment table as well as query combining this info.
I have created a form using a combo box where the user can be selected and the equipment they use is displayed. But in some cases the users have more than 1 piece of equipment e.g. a laptop and pc or a pc and printer. I can only seem to get it to display 1 piece of equipment at a time and also found that the users name appeared twice in the combo box if they had more than 1 piece of equipment associated to them.
Anyone know how i can get the form to display more than 1 piece of equipment thus showing their name once??
Thanks in advanced.