daniel.winson
Registered User.
- Local time
- Today, 16:27
- Joined
- May 28, 2009
- Messages
- 18
Hi,
I have an entry form "frmOrganisations" where a user needs to add multiple entries into a subform "subLocations" from a fixed list (in this case a list of locations serviced by an organisation).
Can you add all possible unique records using an [add all] button, check box, radio button or an option in the combo box?
I have tried using the "Adding (All) Options" to my combo box using VB... but it crashed Access, I now suspect that it isn't designed for what I wanted anyway. - I am trying to sort this out in a separate thread here... http://www.access-programmers.co.uk/forums/showthread.php?t=173264
If I can't figure out a different way to do it I guess I'll go against what I understand are good design principals and add a new record in subLocation called "All" and write the queries to check both for the specific locations requested and then "All".
I have created the buttons in frmOrganisation to show what I mean. zipped MDB file attached. Thanks for your assistance.
I have an entry form "frmOrganisations" where a user needs to add multiple entries into a subform "subLocations" from a fixed list (in this case a list of locations serviced by an organisation).
Can you add all possible unique records using an [add all] button, check box, radio button or an option in the combo box?
I have tried using the "Adding (All) Options" to my combo box using VB... but it crashed Access, I now suspect that it isn't designed for what I wanted anyway. - I am trying to sort this out in a separate thread here... http://www.access-programmers.co.uk/forums/showthread.php?t=173264
If I can't figure out a different way to do it I guess I'll go against what I understand are good design principals and add a new record in subLocation called "All" and write the queries to check both for the specific locations requested and then "All".
I have created the buttons in frmOrganisation to show what I mean. zipped MDB file attached. Thanks for your assistance.