Search results

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

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

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

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