In my attached Access database, I have a listbox on frmPatient that I populate with a new Patient, as their info is entered. Listbox is supposed to show only those patients who's records have NOT yet been printed. Once the patient record has been printed, the patient name is marked as such & is automatically deleted from the listbox. However, eversince I implemented the listbox feature to navigate unPrinted records, I frequently run into the following 2 issues.
Go to the Main form (switchboard), click on Patients & then walk through the following procedure:
1) Open the Patients Window fresh, w/ multiple names already in the List Box
2) click a name (the corresponding record must include hospital data, I think); the name becomes outlined
3) click Delete button
4) this creates one of two types of error:
a) "Update or CancelUpdate without AddNew or Edit"
b) "MS Access has encountered a problem and needs to close"
The interesting thing is that the record DOES get deleted, but doesnt reflect so on the form. Maybe, this might have something to do with the Me.Requery & Me.Refresh that I have at the end of the DELETE button code. Upon commenting those 2, I am get "Update or CancelUpdate without AddNew or Edit". Database attached, help is highly appreciated. Please make a copy of the DB, before attempting ...in case it crashes, you dont have to redownload.