Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    54

    Cool Unanswered: Query/Report Problem... yargh.

    Hi there,

    I have a report that prints out all sales worksheets.
    I would like it to just print out the one a user chooses.

    I'm thinking the best way to do this is to have a concatenated combo box on some form which shows the worksheets (with the customer name, model and serial number), and somehow get the sql query to pull from the form. (WHERE [Machine Detail].DetailID = Forms![Machine Worksheet].cbDetailID

    I have nooooooooo idea how to do this.

    Ideally, I would be able to print one instance of the report from the worksheet form (in my case, I imagine it would be something like WHERE [Machine Detail].DetailID = Forms![Machine Worksheet].txtDetailID).

    Am I on the right track here, is this possible?

    Thanks!

  2. #2
    Join Date
    Aug 2004
    Posts
    54
    Ok if I had a lick of sense to me I would have tried it before I asked....

    I am here to be a senseless monkey for your amusement

Posting Permissions

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