[AccessD] (no subject)

Karen, I'd use a search form -- a simple form with just a couple of 
controls -- one that lets you express the criteria, a list box or combo box 
(which sounds like the right way for you in this instance) that then 
populates with the matching results. You can then use a control event or a 
command button to launch the report.

Susan H.


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