Hello,
I have a table called tblPatient Schedules that has a pretty static listing of the schedule of home visits required to be made for a list of patients. For example, Patient A must have a field worker visit them every Monday. Patient B must have someone visit them every Thursday. I have my tblPatient Schedules bound to a split form called frmPatient Schedules so that I could put buttons in the form top part, and the records are shown in the datasheet part on the bottom. My buttons apply a macro to filter by day (Monday button filters all records that should be seen Monday). So, supervisor can come in Monday morning, click on Monday, and see the required visits to be made that day.
I need a button called btnAddtoVisitLog, when clicked, to copy those filtered records to another table called tblHome Visits. I need them to go to a different table that logs the actual visits that were made rather than that table with a static schedule that only changes when a patient is completely added or deleted from our case load (tblPatient Schedules ). The second table (tblHome Visits) is what will show the actual visits that were done by the field workers
HOWEVER, I want the button to only copy records with an unchecked checkbox which is in a field of the first table. So in the datasheet portion of the split form, the records have a checkbox field called "HOLD". I want the supervisor to be able to check that box for whichever patient's visit is put on hold that day so that when the button, btnAddtoVisitLog is pressed, the records with the unchecked boxes with copy as new records to the table called tblHome Visits.
Thank you so much for your help!