search box needed

  • Thread starter Thread starter TimH
  • Start date Start date
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
 
I would try a standard search box first. Allow the wizard to install a combo
box and let it select what you want to search on, probably patient. Then
right click on the combo to get properties, click on event, and start the
code builder on the afterupdate event. Type:
Me.filter = "[patientid] = """ & me.combo# & """"
Me.filteron = true

The combo# will be listed, like combo9 or combo21. If that doesn't get it
for you go to www.fontstuff.com and check Martin Green's stuff. Or try Allen
Browne at www.allenbromne.com
 
Thankyou
Ill'try


--
timH


Golfinray said:
I would try a standard search box first. Allow the wizard to install a combo
box and let it select what you want to search on, probably patient. Then
right click on the combo to get properties, click on event, and start the
code builder on the afterupdate event. Type:
Me.filter = "[patientid] = """ & me.combo# & """"
Me.filteron = true

The combo# will be listed, like combo9 or combo21. If that doesn't get it
for you go to www.fontstuff.com and check Martin Green's stuff. Or try Allen
Browne at www.allenbromne.com

TimH said:
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
Click to expand...
Click to expand...
 
Back
Top