i have a form that has a combo box on the top of it. the form contains text boxes listing client information. the combo box contains client last names. the user selects a last name from the combo box and the corresponding client info is displayed in the text boxes. from here i want to print a report containing only the client information for that selected record. i am using a randomly generated 'ClientNumber' as a primary key which links the combo box to the displayed information beneth. are there any suggestions please?
You could base your report on a query, with a criteria on the ID field matching the form. When you print the report you make the form invisible, and close or re-visible the form on close of the report.