Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002

    Unanswered: report single record from a form

    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?

  2. #2
    Join Date
    Feb 2002
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts