[AccessD] Looking for easy form solution

FW Salato Center Salato at ky.gov
Sat Oct 24 09:48:12 CDT 2015


Here's the setup - I apologize if I'm giving more information than you guys really need.

I have a table of individual animals. I have a lookup table of species. Each animal is identified by a species. I also have tables for medical records and vaccines, which relate to the individual animals.
Updating medical records and vaccinations for individual animals is easy and already in place. I spent a full week going through paper records and inputting records for the last several years.

However, we do have several multi-animal exhibits where the most efficient input solution for the vet and animal care staff is to pull up a  herd or flock option that initially selects all of that species and lets them make the medical or vaccine update for all. Rarely will they need to update an individual - but that will happen in the case of specific illness or injury. So, in the case of flocks and herds, we need a multiple-selection action type form. That form needs to be flexible enough that we can deselect individual animals because on rare occasionally, one or two of the herd or flock will not be part of the procedure.

I need a form that displays all the animals of the same species - not difficult. I can do that.
I want a select/deselect control that lets the user remove an animal from the group. Not sure about that one.
After deselecting any individual as necessary, the user can then input the necessary medical or vaccine information - probably via a subform - and click OK to commit. I already have the forms that we're using to update these records for individuals. I'm wondering if I could use it as a subform in the multi-select main form? I'm not sure if this is something that the main/sub form arrangement can handle or if I'll need to create a Recordset object to update the  underlying tables.

I'm seriously overthinking it because every time I start in with a solution, I change my mind. I could use a little strategic discussion on the best way to accomplish this. I prefer the easiest route and I can't help but think this should be simpler than I'm making it.

Thanks in advance.

Susan H.


More information about the AccessD mailing list