[AccessD] (no subject)

Hi Karen,

I hope I am not too late to help.

You can use the combo box wizard.

Draw the combo in the form header.

I think it is the third option. Set form to record based on combo box
selection.

Walk all the way through the wizard.

In the row source (I think) on the data properties tab. This is query
builder.

This where I forgot some create a field called Patient Name ( or what ever
you want)
= Lname&", "&fname&" "&Mname

Have it sort acending.

When some one selects a patient the form populates with there data.

HTH

Joe Hecht
Joe at anamericanjoe.us
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
krosenstiel at comcast.net
Sent: Monday, February 25, 2008 9:35 AM
To: DBA-AccessD
Subject: [AccessD] (no subject)

>From a patient database in Access 2003, I want to pick the right patient
for a report of individual details. I have fields Lname, Fname and Mname. In
the query on the Lname field I have the following as the criteria:

Like "*" & [Enter Last Name] & "*"

This works fine to pick all the Johnsons, including "Johnson, Jr." However,
the report is then returning all the Johnsons in sequence, but I only want 1
particular Johnson with his/her individual details. How do I get the query
to give me a list of "Johnsons," including first and middle names, from
which I can pick the right patient to plop into the report?

MTIA -- and please keep it simple, I'm not very advanced with Access


--
Karen Rosenstiel
Seattle WA USA
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com