Hi all! I'm a receptionist trying to get access to work the way I want it to so I can work with our mailing list. I've done it before at another job site, but there I was able to take examples from a database that had been professionally done (cut&paste and tweak -- ain't it a wonderful thing?). Anyway, so here's my problem.
I'm doing up a form that has a subform. The subform shows the complete set of information for an individual on our list. The purpose of the main form is the combo box which lists the various organizations that the people on the ML belong to. This way, whenever I need to add a new person or edit an entry, I can choose the organization from the combo, navigate to the correct entry (if necessary), and do my work.
It works *to a degree* as I used the Wizard to link the Subform to the Main form via the Organization Combo when I created the Subform. However, here are my big problems:
- Whenever I choose an option from the Combo, it adds it as a new entry on the table from which it gets its data (I only want one listing per organization -- the table is one column only listing all the organizations, created specifically for the Combo)
- If I try to lock the Combo, I can't choose an option
- If I change the table from which the Combo gets its info so that it doesn't accept duplicate entries, then there are problems whenever I try to access organizations with several people listed
When I worked on this at my old job, I'd managed to do something with the AfterUpdate command -- but without the template I had, the coding is Greek to me.
I appreciate any help given. Thank you kindly.
Jaime
I'm doing up a form that has a subform. The subform shows the complete set of information for an individual on our list. The purpose of the main form is the combo box which lists the various organizations that the people on the ML belong to. This way, whenever I need to add a new person or edit an entry, I can choose the organization from the combo, navigate to the correct entry (if necessary), and do my work.
It works *to a degree* as I used the Wizard to link the Subform to the Main form via the Organization Combo when I created the Subform. However, here are my big problems:
- Whenever I choose an option from the Combo, it adds it as a new entry on the table from which it gets its data (I only want one listing per organization -- the table is one column only listing all the organizations, created specifically for the Combo)
- If I try to lock the Combo, I can't choose an option
- If I change the table from which the Combo gets its info so that it doesn't accept duplicate entries, then there are problems whenever I try to access organizations with several people listed
When I worked on this at my old job, I'd managed to do something with the AfterUpdate command -- but without the template I had, the coding is Greek to me.
I appreciate any help given. Thank you kindly.
Jaime
