Recent content by Griffin

I have a form with a sub form that opens based on a record search for a patient, whose details are displayed at the top in the main form. The sub form displays visit information for that patient (there can be multiple visits). On opening the sub form is filtered and only shows one record at a...

Thanks for all your suggestions Kevin...much appreciated and it worked!

I have a button that when clicked is used to switch to a form displaying a record details based on a search by surname using a combo box. The record chosen by using the combo box is also displayed lower down on the initial form. My problem is with multiple surname entries, it keeps switching to...

"I would like the user to be able to type OR select a surname from the dropdown list and where there are multiple entries of that surname select the correct record." It is a Combo box not a List box; the chosen record is displayed in the fields below in the same form. If it is the incorrect...

:mad: I have a combo box which is being used for surname searching. It displays surnames in the first column and first names in the second column. I would like the user to be able to type or select a surname from the dropdown list and where there are multiple entries of that surname select the...

Thankyou Jon! Thanks so much for all your help; I definately wouldn't have worked it out by myself! It was good to learn about how to apply the use of multiple queries. I have applied your primary query to 11 others; all with success :)

I am quite frustrated at not being able to solve this problem in a Db I am developing for my wife. :eek: I have searched through a number of solutions to similar thread questions. I tried using "Distinct" in the SQL statement, Grouping using Max, Min, First and Last all without success. So...