Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2011

    Unanswered: Report using input JUST keyed in form

    Guys and gals,

    Hope you guys can help me with this question. I have searched all forums but could not find EXACTLY what I want to achieve.

    I have a form contains following fields:

    -Order ID
    -Order Date
    -Client Name

    For each order I will have a subform which details different products.

    What I want to achieve:
    When a customer come in person and make an order, I will fill in the form (ID, Date, etc) and also subform. Once, I finish filling in, I want to print a port for client to confirm what they just order and sign.

    My question:
    Can I have a button in my form, so when I click it, a report for each order will be prepared detailiing what I JUST keyed in ?

    Thanks heaps,

  2. #2
    Join Date
    Apr 2005
    Zagreb - Croatia
    Yes, you can do it, but send a short example of your MDB, (access 2000 or 2002-2003).

  3. #3
    Join Date
    Jun 2011
    Thanks MStef-ZG for your willingness to help. I haven't actually started yet, so I don't have the database ready.

    Any general direction/guidance will be helpful at this stage.


  4. #4
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    The secret here is to first Save the New Record then Print a Report with that single Record. Allen Browne has an excellent little tutorial on the subject

    Microsoft Access tips: Print the record in the form

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  5. #5
    Join Date
    Jun 2011
    Thanks Linq. I was able to achieve the same result using Forms![formName]![controlName].Value to get the value from the form. Cheers.

Posting Permissions

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