Selecting a record from a query

[petebevans]

I have developed a database which uses a form with a combo box (unbound) to select PatientHospitalNo (Primary Key) from the PatientDetailsTable and display patient information in this form and patient treatment episodes in a sub form. The customer has decided that they would prefer to select a patient by name rather than by hospital no. In order not to have to modify the existing form too much and to reduce the chance of selecting the wrong patient with the same name, I created a form launched by a command button on the main form. This form displayed the results of a query on a specific patient name, returning their date of birth and hospital no. What I wanted to do was to be able to select the correct record from this query and on closing the form input the PatientHospitalNo into the combo box on the main form. I don't want to add the record to the combo source as it already exists. Rather I want it to put the required PatientHospitalNo into the combo box as if I had manually selected that record from the combo box. Is this possible to do or is there another solution?

 

[petebevans]

Thanks for that Pat. Easy when you know how isn't it? Sorry for delay in replying - life has been rather hectic!