tom22london
Programmer
Hi members,
I have a hospital database having a table name ADMISSION, I have a form(ADMISSIONCHARGESDETAIL)through which i charge(fee) patient once they are ready to get discharged from the hospital. this form has primary feild ADMISSION_ID, which is linked with the ADMISSION table's admission_id. I want to put a command button on the form through which i want to update the admission table by putting system date in Dischrage date column of admission table.
following is the stored query which I am running on the click event of the "discharge patient" command button (form name is admissionchargesdetailed)through micro(which calls the stored query), but it always ask for a paramenter (Admission_ID)
UPDATE Admission SET Admission.discharge_date = Date()
WHERE (((Admission.discharge_date) Is Null) AND ((Admission.adm_id)=[Enter Admission ID]));
I want that on clicking Discharge Patient command button, it automatically update the admission table's with discharge date as current system date, for the current record on the form using the admission_id.
I have a hospital database having a table name ADMISSION, I have a form(ADMISSIONCHARGESDETAIL)through which i charge(fee) patient once they are ready to get discharged from the hospital. this form has primary feild ADMISSION_ID, which is linked with the ADMISSION table's admission_id. I want to put a command button on the form through which i want to update the admission table by putting system date in Dischrage date column of admission table.
following is the stored query which I am running on the click event of the "discharge patient" command button (form name is admissionchargesdetailed)through micro(which calls the stored query), but it always ask for a paramenter (Admission_ID)
UPDATE Admission SET Admission.discharge_date = Date()
WHERE (((Admission.discharge_date) Is Null) AND ((Admission.adm_id)=[Enter Admission ID]));
I want that on clicking Discharge Patient command button, it automatically update the admission table's with discharge date as current system date, for the current record on the form using the admission_id.