search box needed

Tech-Archive recommends: Fix windows errors by optimizing your registry

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
--
timH
.

Quantcast