N
Nathan-bfhd
I'll try to be concise, but I have to give quite a bit of info to paint the
picture accurately.
I have a form with many subforms. One subform has child information (FName,
LName, DOB, etc), which runs off of a Child Table. Another subform has
Immunization information (a shots field-with 17 different shots; a status
field with 6 options-i.e. needs or current; a ChildID field to tie the
Immunization record to the Child Table; a VisitID field to tie the
Immunization to a visit), which all runs off of an Immunization Table.
Each time one of our nurses enters in immunization info for a new child, she
has to select the shot type, then the status for each applicable shot (which
is often upward of 10). I currently have the shot type as a combo box for
her to select from, but what would be better is if there was a way for me to
auto-populate every shot type as an entry with the status field remaining
blank so that she could just go through for each shot that is applicaple and
enter the status of it. How can I do this? Please let me know if I need to
be more specific about any details of my form or tables.
picture accurately.
I have a form with many subforms. One subform has child information (FName,
LName, DOB, etc), which runs off of a Child Table. Another subform has
Immunization information (a shots field-with 17 different shots; a status
field with 6 options-i.e. needs or current; a ChildID field to tie the
Immunization record to the Child Table; a VisitID field to tie the
Immunization to a visit), which all runs off of an Immunization Table.
Each time one of our nurses enters in immunization info for a new child, she
has to select the shot type, then the status for each applicable shot (which
is often upward of 10). I currently have the shot type as a combo box for
her to select from, but what would be better is if there was a way for me to
auto-populate every shot type as an entry with the status field remaining
blank so that she could just go through for each shot that is applicaple and
enter the status of it. How can I do this? Please let me know if I need to
be more specific about any details of my form or tables.