NEED HELP!!! trouble with Find Record

  • Thread starter Thread starter rookie
  • Start date Start date
R

rookie

I am trying to create a "find patient" box for our company database.
I created an "unbound" combo box in the forms view and went to
"after update" in the properties section to create a macro.

In the "unbound" combo box, I created 3 columns.
Column 1 = Patient Name
Column 2 = MDACC# (also known as patient medical #)
Column 3 = Date (office visit date)

The purpose of the 3 columns combo box is for the user
to open a combo box and select the appropriate person and date to review
it's data. Thus, the combo box will automatically display it's data in the
forms
view.

In the macro under Action, I selected:

GoToControl
Control Name [MDACC#]

FindRecord
Find What =[MDACC#]
Match Whole Field
Match case No
Search All
Search as Formatted No
Only current field Yes
Find First Yes

After doing all this, my "unbound" combo box looks great. However, when
I select the patient names in the combo box the data does NOT change. I know
it's because of my "after update" macro isn't done correctly. PLEASE HELP!!!

thanks,
rookie
 
Combo boxes have a "bound column", which by default is column 1. In your case
column 1 is Patient Name, not MDACC, so you can try one of two things.

1) rearrange your rowsource query so that MDACC is the first column.

2)Open the properties sheet for your combo box, go to the data tab, and
change the bound column to 2.

See if this solves your problem. If not post back
 
Hi Sean,
Thanks for the tip. I was reading my Access book and thought it was a better
idea to use the Find Record Wizard in the forms views. It worked great!

However, I'm having problems with the data refreshing. For example, if John
Smith visited the doctor 4 times. The combo box shows 4 visit dates. But,
when I select visit 2, the data shows only visit 1 data and not visit 2.
Thus, it only displays the 1st visit date information and not the others. Why
is that? Did I miss something?

I have listed the VBA codes below from the Wizard.

Private Sub Combo64_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Patient Name] = '" & Me![Combo64] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Thanks!
Rookie

Beetle said:
Combo boxes have a "bound column", which by default is column 1. In your case
column 1 is Patient Name, not MDACC, so you can try one of two things.

1) rearrange your rowsource query so that MDACC is the first column.

2)Open the properties sheet for your combo box, go to the data tab, and
change the bound column to 2.

See if this solves your problem. If not post back

--
_________

Sean Bailey


rookie said:
I am trying to create a "find patient" box for our company database.
I created an "unbound" combo box in the forms view and went to
"after update" in the properties section to create a macro.

In the "unbound" combo box, I created 3 columns.
Column 1 = Patient Name
Column 2 = MDACC# (also known as patient medical #)
Column 3 = Date (office visit date)

The purpose of the 3 columns combo box is for the user
to open a combo box and select the appropriate person and date to review
it's data. Thus, the combo box will automatically display it's data in the
forms
view.

In the macro under Action, I selected:

GoToControl
Control Name [MDACC#]

FindRecord
Find What =[MDACC#]
Match Whole Field
Match case No
Search All
Search as Formatted No
Only current field Yes
Find First Yes

After doing all this, my "unbound" combo box looks great. However, when
I select the patient names in the combo box the data does NOT change. I know
it's because of my "after update" macro isn't done correctly. PLEASE HELP!!!

thanks,
rookie
Click to expand...
Click to expand...
 
That's because the code the wizard created for you is looking at the field
[Patient name] and finding the first record for that patient. If all you do
is change the visit date, but the patient name stays the same, then it won't
update.

HOWEVER, before we get too involved in trying to solve this problem, maybe
we should take a step back. From your two posts so far, I get the feeling
that you have all of this information in one table. If so, then your table
design is faulty, and that needs to be fixed before you spend a lot of time
trying to get your form to work.

The information about a patient's visits should be stored in a separate
table than the information about the patient. They would be related via
PatientID (hopefully you have a PatientID field and you're not using
PatientName as your primary key - actually, PatientName should be two
separate fields, LastName and FirstName). Then you would set up a
MainForm/SubForm where the information about a patient's visits would be
displayed in the subform.

If I've misunderstood, and this info is already in two separate tables, then
post back for more help on getting your combo box to work right.

--
_________

Sean Bailey


rookie said:
Hi Sean,
Thanks for the tip. I was reading my Access book and thought it was a better
idea to use the Find Record Wizard in the forms views. It worked great!

However, I'm having problems with the data refreshing. For example, if John
Smith visited the doctor 4 times. The combo box shows 4 visit dates. But,
when I select visit 2, the data shows only visit 1 data and not visit 2.
Thus, it only displays the 1st visit date information and not the others. Why
is that? Did I miss something?

I have listed the VBA codes below from the Wizard.

Private Sub Combo64_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Patient Name] = '" & Me![Combo64] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Thanks!
Rookie

Beetle said:
Combo boxes have a "bound column", which by default is column 1. In your case
column 1 is Patient Name, not MDACC, so you can try one of two things.

1) rearrange your rowsource query so that MDACC is the first column.

2)Open the properties sheet for your combo box, go to the data tab, and
change the bound column to 2.

See if this solves your problem. If not post back

--
_________

Sean Bailey


rookie said:
I am trying to create a "find patient" box for our company database.
I created an "unbound" combo box in the forms view and went to
"after update" in the properties section to create a macro.

In the "unbound" combo box, I created 3 columns.
Column 1 = Patient Name
Column 2 = MDACC# (also known as patient medical #)
Column 3 = Date (office visit date)

The purpose of the 3 columns combo box is for the user
to open a combo box and select the appropriate person and date to review
it's data. Thus, the combo box will automatically display it's data in the
forms
view.

In the macro under Action, I selected:

GoToControl
Control Name [MDACC#]

FindRecord
Find What =[MDACC#]
Match Whole Field
Match case No
Search All
Search as Formatted No
Only current field Yes
Find First Yes

After doing all this, my "unbound" combo box looks great. However, when
I select the patient names in the combo box the data does NOT change. I know
it's because of my "after update" macro isn't done correctly. PLEASE HELP!!!

thanks,
rookie
Click to expand...
Click to expand...
Click to expand...
 
Use the DateAdd function. You can find info in your Access help file or at
this link;

http://msdn2.microsoft.com/en-us/library/aa262710(VS.60).aspx

HTH
--
_________

Sean Bailey


rookie said:
Hi Sean,
Thanks for the tip. I was reading my Access book and thought it was a better
idea to use the Find Record Wizard in the forms views. It worked great!

However, I'm having problems with the data refreshing. For example, if John
Smith visited the doctor 4 times. The combo box shows 4 visit dates. But,
when I select visit 2, the data shows only visit 1 data and not visit 2.
Thus, it only displays the 1st visit date information and not the others. Why
is that? Did I miss something?

I have listed the VBA codes below from the Wizard.

Private Sub Combo64_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Patient Name] = '" & Me![Combo64] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Thanks!
Rookie

Beetle said:
Combo boxes have a "bound column", which by default is column 1. In your case
column 1 is Patient Name, not MDACC, so you can try one of two things.

1) rearrange your rowsource query so that MDACC is the first column.

2)Open the properties sheet for your combo box, go to the data tab, and
change the bound column to 2.

See if this solves your problem. If not post back

--
_________

Sean Bailey


rookie said:
I am trying to create a "find patient" box for our company database.
I created an "unbound" combo box in the forms view and went to
"after update" in the properties section to create a macro.

In the "unbound" combo box, I created 3 columns.
Column 1 = Patient Name
Column 2 = MDACC# (also known as patient medical #)
Column 3 = Date (office visit date)

The purpose of the 3 columns combo box is for the user
to open a combo box and select the appropriate person and date to review
it's data. Thus, the combo box will automatically display it's data in the
forms
view.

In the macro under Action, I selected:

GoToControl
Control Name [MDACC#]

FindRecord
Find What =[MDACC#]
Match Whole Field
Match case No
Search All
Search as Formatted No
Only current field Yes
Find First Yes

After doing all this, my "unbound" combo box looks great. However, when
I select the patient names in the combo box the data does NOT change. I know
it's because of my "after update" macro isn't done correctly. PLEASE HELP!!!

thanks,
rookie
Click to expand...
Click to expand...
Click to expand...
 
Disregard this last post. I was replying to another thread but posted it here
by mistake.
--
_________

Sean Bailey


Beetle said:
Use the DateAdd function. You can find info in your Access help file or at
this link;

http://msdn2.microsoft.com/en-us/library/aa262710(VS.60).aspx

HTH
--
_________

Sean Bailey


rookie said:
Hi Sean,
Thanks for the tip. I was reading my Access book and thought it was a better
idea to use the Find Record Wizard in the forms views. It worked great!

However, I'm having problems with the data refreshing. For example, if John
Smith visited the doctor 4 times. The combo box shows 4 visit dates. But,
when I select visit 2, the data shows only visit 1 data and not visit 2.
Thus, it only displays the 1st visit date information and not the others. Why
is that? Did I miss something?

I have listed the VBA codes below from the Wizard.

Private Sub Combo64_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Patient Name] = '" & Me![Combo64] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Thanks!
Rookie

Beetle said:
Combo boxes have a "bound column", which by default is column 1. In your case
column 1 is Patient Name, not MDACC, so you can try one of two things.

1) rearrange your rowsource query so that MDACC is the first column.

2)Open the properties sheet for your combo box, go to the data tab, and
change the bound column to 2.

See if this solves your problem. If not post back

--
_________

Sean Bailey


:

I am trying to create a "find patient" box for our company database.
I created an "unbound" combo box in the forms view and went to
"after update" in the properties section to create a macro.

In the "unbound" combo box, I created 3 columns.
Column 1 = Patient Name
Column 2 = MDACC# (also known as patient medical #)
Column 3 = Date (office visit date)

The purpose of the 3 columns combo box is for the user
to open a combo box and select the appropriate person and date to review
it's data. Thus, the combo box will automatically display it's data in the
forms
view.

In the macro under Action, I selected:

GoToControl
Control Name [MDACC#]

FindRecord
Find What =[MDACC#]
Match Whole Field
Match case No
Search All
Search as Formatted No
Only current field Yes
Find First Yes

After doing all this, my "unbound" combo box looks great. However, when
I select the patient names in the combo box the data does NOT change. I know
it's because of my "after update" macro isn't done correctly. PLEASE HELP!!!

thanks,
rookie
Click to expand...
Click to expand...
Click to expand...
 
Hi Sean,
I created my database with primarily 2 tables. One table is
"tbl_Demographic" and the 2nd table is "tbl_Main". I linked these 2 tables in
a query ("qry_Find_patient") by using the patient medical record number (like
the PatientID) as the primary key. Afterwards, I took the query and made a
form.

After I made the form using the wizard, I then used the wizard "Find Record"
to create my search box.

Thus, I need your help in getting the combo box to work.

Thanks again!
Rookie

Beetle said:
That's because the code the wizard created for you is looking at the field
[Patient name] and finding the first record for that patient. If all you do
is change the visit date, but the patient name stays the same, then it won't
update.

HOWEVER, before we get too involved in trying to solve this problem, maybe
we should take a step back. From your two posts so far, I get the feeling
that you have all of this information in one table. If so, then your table
design is faulty, and that needs to be fixed before you spend a lot of time
trying to get your form to work.

The information about a patient's visits should be stored in a separate
table than the information about the patient. They would be related via
PatientID (hopefully you have a PatientID field and you're not using
PatientName as your primary key - actually, PatientName should be two
separate fields, LastName and FirstName). Then you would set up a
MainForm/SubForm where the information about a patient's visits would be
displayed in the subform.

If I've misunderstood, and this info is already in two separate tables, then
post back for more help on getting your combo box to work right.

--
_________

Sean Bailey


rookie said:
Hi Sean,
Thanks for the tip. I was reading my Access book and thought it was a better
idea to use the Find Record Wizard in the forms views. It worked great!

However, I'm having problems with the data refreshing. For example, if John
Smith visited the doctor 4 times. The combo box shows 4 visit dates. But,
when I select visit 2, the data shows only visit 1 data and not visit 2.
Thus, it only displays the 1st visit date information and not the others. Why
is that? Did I miss something?

I have listed the VBA codes below from the Wizard.

Private Sub Combo64_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Patient Name] = '" & Me![Combo64] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Thanks!
Rookie

Beetle said:
Combo boxes have a "bound column", which by default is column 1. In your case
column 1 is Patient Name, not MDACC, so you can try one of two things.

1) rearrange your rowsource query so that MDACC is the first column.

2)Open the properties sheet for your combo box, go to the data tab, and
change the bound column to 2.

See if this solves your problem. If not post back

--
_________

Sean Bailey


:

I am trying to create a "find patient" box for our company database.
I created an "unbound" combo box in the forms view and went to
"after update" in the properties section to create a macro.

In the "unbound" combo box, I created 3 columns.
Column 1 = Patient Name
Column 2 = MDACC# (also known as patient medical #)
Column 3 = Date (office visit date)

The purpose of the 3 columns combo box is for the user
to open a combo box and select the appropriate person and date to review
it's data. Thus, the combo box will automatically display it's data in the
forms
view.

In the macro under Action, I selected:

GoToControl
Control Name [MDACC#]

FindRecord
Find What =[MDACC#]
Match Whole Field
Match case No
Search All
Search as Formatted No
Only current field Yes
Find First Yes

After doing all this, my "unbound" combo box looks great. However, when
I select the patient names in the combo box the data does NOT change. I know
it's because of my "after update" macro isn't done correctly. PLEASE HELP!!!

thanks,
rookie
Click to expand...
Click to expand...
Click to expand...
 
Which table contains the patient info and which table contains the visit info?

--
_________

Sean Bailey


rookie said:
Hi Sean,
I created my database with primarily 2 tables. One table is
"tbl_Demographic" and the 2nd table is "tbl_Main". I linked these 2 tables in
a query ("qry_Find_patient") by using the patient medical record number (like
the PatientID) as the primary key. Afterwards, I took the query and made a
form.

After I made the form using the wizard, I then used the wizard "Find Record"
to create my search box.

Thus, I need your help in getting the combo box to work.

Thanks again!
Rookie

Beetle said:
That's because the code the wizard created for you is looking at the field
[Patient name] and finding the first record for that patient. If all you do
is change the visit date, but the patient name stays the same, then it won't
update.

HOWEVER, before we get too involved in trying to solve this problem, maybe
we should take a step back. From your two posts so far, I get the feeling
that you have all of this information in one table. If so, then your table
design is faulty, and that needs to be fixed before you spend a lot of time
trying to get your form to work.

The information about a patient's visits should be stored in a separate
table than the information about the patient. They would be related via
PatientID (hopefully you have a PatientID field and you're not using
PatientName as your primary key - actually, PatientName should be two
separate fields, LastName and FirstName). Then you would set up a
MainForm/SubForm where the information about a patient's visits would be
displayed in the subform.

If I've misunderstood, and this info is already in two separate tables, then
post back for more help on getting your combo box to work right.

--
_________

Sean Bailey


rookie said:
Hi Sean,
Thanks for the tip. I was reading my Access book and thought it was a better
idea to use the Find Record Wizard in the forms views. It worked great!

However, I'm having problems with the data refreshing. For example, if John
Smith visited the doctor 4 times. The combo box shows 4 visit dates. But,
when I select visit 2, the data shows only visit 1 data and not visit 2.
Thus, it only displays the 1st visit date information and not the others. Why
is that? Did I miss something?

I have listed the VBA codes below from the Wizard.

Private Sub Combo64_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Patient Name] = '" & Me![Combo64] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Thanks!
Rookie

:

Combo boxes have a "bound column", which by default is column 1. In your case
column 1 is Patient Name, not MDACC, so you can try one of two things.

1) rearrange your rowsource query so that MDACC is the first column.

2)Open the properties sheet for your combo box, go to the data tab, and
change the bound column to 2.

See if this solves your problem. If not post back

--
_________

Sean Bailey


:

I am trying to create a "find patient" box for our company database.
I created an "unbound" combo box in the forms view and went to
"after update" in the properties section to create a macro.

In the "unbound" combo box, I created 3 columns.
Column 1 = Patient Name
Column 2 = MDACC# (also known as patient medical #)
Column 3 = Date (office visit date)

The purpose of the 3 columns combo box is for the user
to open a combo box and select the appropriate person and date to review
it's data. Thus, the combo box will automatically display it's data in the
forms
view.

In the macro under Action, I selected:

GoToControl
Control Name [MDACC#]

FindRecord
Find What =[MDACC#]
Match Whole Field
Match case No
Search All
Search as Formatted No
Only current field Yes
Find First Yes

After doing all this, my "unbound" combo box looks great. However, when
I select the patient names in the combo box the data does NOT change. I know
it's because of my "after update" macro isn't done correctly. PLEASE HELP!!!

thanks,
rookie
Click to expand...
Click to expand...
Click to expand...
 
The "tbl_demographic" contains the patient information such as First Name,
Last Name, Date of Birth, and so forth.

The "tbl_Main" contains the office visit information such as medical status
and office date.

Thus, I linked both tables together into 1 query by medical record number.
Afterwards, I made the "Find Record" form using the wizard from the query.

thank you,
Rookie
Beetle said:
Which table contains the patient info and which table contains the visit info?

--
_________

Sean Bailey


rookie said:
Hi Sean,
I created my database with primarily 2 tables. One table is
"tbl_Demographic" and the 2nd table is "tbl_Main". I linked these 2 tables in
a query ("qry_Find_patient") by using the patient medical record number (like
the PatientID) as the primary key. Afterwards, I took the query and made a
form.

After I made the form using the wizard, I then used the wizard "Find Record"
to create my search box.

Thus, I need your help in getting the combo box to work.

Thanks again!
Rookie

Beetle said:
That's because the code the wizard created for you is looking at the field
[Patient name] and finding the first record for that patient. If all you do
is change the visit date, but the patient name stays the same, then it won't
update.

HOWEVER, before we get too involved in trying to solve this problem, maybe
we should take a step back. From your two posts so far, I get the feeling
that you have all of this information in one table. If so, then your table
design is faulty, and that needs to be fixed before you spend a lot of time
trying to get your form to work.

The information about a patient's visits should be stored in a separate
table than the information about the patient. They would be related via
PatientID (hopefully you have a PatientID field and you're not using
PatientName as your primary key - actually, PatientName should be two
separate fields, LastName and FirstName). Then you would set up a
MainForm/SubForm where the information about a patient's visits would be
displayed in the subform.

If I've misunderstood, and this info is already in two separate tables, then
post back for more help on getting your combo box to work right.

--
_________

Sean Bailey


:

Hi Sean,
Thanks for the tip. I was reading my Access book and thought it was a better
idea to use the Find Record Wizard in the forms views. It worked great!

However, I'm having problems with the data refreshing. For example, if John
Smith visited the doctor 4 times. The combo box shows 4 visit dates. But,
when I select visit 2, the data shows only visit 1 data and not visit 2.
Thus, it only displays the 1st visit date information and not the others. Why
is that? Did I miss something?

I have listed the VBA codes below from the Wizard.

Private Sub Combo64_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.Recordset.Clone
rs.FindFirst "[Patient Name] = '" & Me![Combo64] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Thanks!
Rookie

:

Combo boxes have a "bound column", which by default is column 1. In your case
column 1 is Patient Name, not MDACC, so you can try one of two things.

1) rearrange your rowsource query so that MDACC is the first column.

2)Open the properties sheet for your combo box, go to the data tab, and
change the bound column to 2.

See if this solves your problem. If not post back

--
_________

Sean Bailey


:

I am trying to create a "find patient" box for our company database.
I created an "unbound" combo box in the forms view and went to
"after update" in the properties section to create a macro.

In the "unbound" combo box, I created 3 columns.
Column 1 = Patient Name
Column 2 = MDACC# (also known as patient medical #)
Column 3 = Date (office visit date)

The purpose of the 3 columns combo box is for the user
to open a combo box and select the appropriate person and date to review
it's data. Thus, the combo box will automatically display it's data in the
forms
view.

In the macro under Action, I selected:

GoToControl
Control Name [MDACC#]

FindRecord
Find What =[MDACC#]
Match Whole Field
Match case No
Search All
Search as Formatted No
Only current field Yes
Find First Yes

After doing all this, my "unbound" combo box looks great. However, when
I select the patient names in the combo box the data does NOT change. I know
it's because of my "after update" macro isn't done correctly. PLEASE HELP!!!

thanks,
rookie
Click to expand...
Click to expand...
Click to expand...
 
The "tbl_demographic" contains the patient information such as First Name,
Last Name, Date of Birth, and so forth.

The "tbl_Main" contains the office visit information such as medical status
and office date.

Thus, I linked both tables together into 1 query by medical record number.
Afterwards, I made the "Find Record" form using the wizard from the query.
Click to expand...

Rather than basing your form on a Query, consider using a Form based on
tbl_demographic with a continuous Subform based on tbl_main. This will let you
show all the visits for a patient on one screen; and it will make your search
(and your updating) easier.

John W. Vinson [MVP]
 
Hi John,
I took your advice and unfortunately it didn't work. I opened
"tbl_demographic" and created a subform using the wizard using "tbl_Main".
Afterwards, I went to create "Find Record" using the combo box wizard.
Consequently, I experienced the same problem where it only retrieved the 1st
record of each patient visit.

Am I doing something wrong?

Thanks!
Rookie
 
Hi John,
I took your advice and unfortunately it didn't work. I opened
"tbl_demographic" and created a subform using the wizard using "tbl_Main".
Afterwards, I went to create "Find Record" using the combo box wizard.
Consequently, I experienced the same problem where it only retrieved the 1st
record of each patient visit.

Am I doing something wrong?
Click to expand...

Where is the combo - on the mainform, based on tbl_demographic? Perhaps you
could post the RowSource (post the SQL view of the query) of the combo, and
the wizard generated code in its AfterUpdate event.

If you just manually navigate through records on the form, do you see all of
the visits for each patient - or only one?

John W. Vinson [MVP]
 
Hi John,

The SQL view below is combining 2 tables: tbl_Demographic and
tbl_LymphPhysicalExam (aka tbl_Main) into 1 qry.

SELECT tbl_Demographic!LastName & ", " & tbl_Demographic!FirstName AS
[Patient Name], tbl_LymphPhysicalExam.[MDACC#], tbl_LymphPhysicalExam.Date,
tbl_LymphPhysicalExam.[Upper Lip Circumference]
FROM tbl_Demographic INNER JOIN tbl_LymphPhysicalExam ON
tbl_Demographic.[MDACC#] = tbl_LymphPhysicalExam.[MDACC#]
ORDER BY tbl_Demographic!LastName & ", " & tbl_Demographic!FirstName,
tbl_LymphPhysicalExam.[MDACC#], tbl_LymphPhysicalExam.Date;

I have also listed the wizard generated AfterUpdated Event code below.
Everytime I click on the combo box, it only pulls 1st patient data and not
the 2nd or 3rd.

Private Sub Combo64_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object

Set rs = Me.RecordsetClone
rs.FindFirst "[Patient Name] = '" & Me![Combo64] & "' And [Date] = "
[MDACC#]" & Me![Date] & "[MDACC#]"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

Yes, if I manually navigate through the records, I can see ALL of them.

Thanks again!
Rookie
 
The SQL view below is combining 2 tables: tbl_Demographic and
tbl_LymphPhysicalExam (aka tbl_Main) into 1 qry.
Click to expand...

That is exactly and precisely the reason you're having the problem.

When you find a record in this recordset, it contains one and only one visit:
the first, since you have it sorted. That's what you're ASKING for - each
record in this recordset is one visit, so you're finding one visit, as
requested!

If you want to see multiple visits, do as I suggested: base a form on
tbl_demographic and a subform on tbl_LymphPhysicalExam.


John W. Vinson [MVP]
 
Back
Top