P
Pat Dools
I have a database that has one main table and form that contains 'edit'
records of all records that have data entry mistakes. Each of these records
has a status ('New', 'Fixed', 'In Process', etc.).
On the Switchboard below, I also have a Combo box that looks up to
another table (different from the 'Status' table that acts as the actual
Record Source for my Switchboard form) to get all the unique patient
records/IDs from the data set so a patient record can be chosen.
From the Switchboard, our user would like to: 1) Click on a command button
that will get a Count of all records that have a certain status (e.g., 'New',
'Fixed', 'In Process', etc.). 2) Then, they would like to click on another
command button that would open up the form that contains all Edit Records
with the Status they just got the Count from (in Step #1 above), so they
could scroll thru those records for review. 3) Finally, how I can get all
records with a status of new AND pertain to the patient selected from my
combo box on the Switchboard form ('fEnterPatientInfo')?
What I need is to be able to add this this code:
DoCmd.OpenForm "FormStatus", , , "Status = 'New' "
I've played with variations of the code below, but
cannot get it to fly:
DoCmd.OpenForm "FormStatus", , , "Status = 'New' " & [patient]=
[forms]![fEnterPatientInfo]![selectpatient]
where [patient] is the Patient ID number in the header of the form
"FormStatus" that I would like to filter on (in addition to the 'Status'
field).
Thank you.
records of all records that have data entry mistakes. Each of these records
has a status ('New', 'Fixed', 'In Process', etc.).
On the Switchboard below, I also have a Combo box that looks up to
another table (different from the 'Status' table that acts as the actual
Record Source for my Switchboard form) to get all the unique patient
records/IDs from the data set so a patient record can be chosen.
From the Switchboard, our user would like to: 1) Click on a command button
that will get a Count of all records that have a certain status (e.g., 'New',
'Fixed', 'In Process', etc.). 2) Then, they would like to click on another
command button that would open up the form that contains all Edit Records
with the Status they just got the Count from (in Step #1 above), so they
could scroll thru those records for review. 3) Finally, how I can get all
records with a status of new AND pertain to the patient selected from my
combo box on the Switchboard form ('fEnterPatientInfo')?
What I need is to be able to add this this code:
DoCmd.OpenForm "FormStatus", , , "Status = 'New' "
I've played with variations of the code below, but
cannot get it to fly:
DoCmd.OpenForm "FormStatus", , , "Status = 'New' " & [patient]=
[forms]![fEnterPatientInfo]![selectpatient]
where [patient] is the Patient ID number in the header of the form
"FormStatus" that I would like to filter on (in addition to the 'Status'
field).
Thank you.