T
TimH
I read and followed jurseygirl54 progres however i am stuck:
the idea is for a research assistant to update data on a list of patients
and rather than scrolling through a long list of patients I wanted a search
form to link to the patient form and open the specific patient. I made a
command button to oppen a Search_Patient form.
I made a form named frmPatient_Search its record source is tblPatients and
its Filter is tblPatients!ID=Form!frmPatient_Search.combobox
The unbound combobox Row Sourse Type is Table/Query and the
Row Source: SQL
staement:Select[tblPatients].[ID],[tblPatients].[tblPatientsLastName],
I noticed on Combo1_AfterUpdate() code was automaticaly placed in creating a
Me.Recordset.Clone
on exit for the combobox the Clone recordset oppens and not the actual
patient form.
Please help
the idea is for a research assistant to update data on a list of patients
and rather than scrolling through a long list of patients I wanted a search
form to link to the patient form and open the specific patient. I made a
command button to oppen a Search_Patient form.
I made a form named frmPatient_Search its record source is tblPatients and
its Filter is tblPatients!ID=Form!frmPatient_Search.combobox
The unbound combobox Row Sourse Type is Table/Query and the
Row Source: SQL
staement:Select[tblPatients].[ID],[tblPatients].[tblPatientsLastName],
I noticed on Combo1_AfterUpdate() code was automaticaly placed in creating a
Me.Recordset.Clone
on exit for the combobox the Clone recordset oppens and not the actual
patient form.
Please help