Results 1 to 3 of 3
  1. #1
    nick404's Avatar
    nick404 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    May 2015
    Location
    Wisconsin
    Posts
    352

    Allowing User Input in Report View

    I have a report made that generates a sort of order form for a department. They select from a query what parts they need, then run the report which shows them what they selected, item description, supplier, and prices (as well as a total). I need to include a small section above (in the header) where the user can then type in their name, the credit card number they are using, the contact they are ordering through, and who approved the order. These are some things the user would need to type right into the report before printing it. Is there anyway I can get a textbox to keep what they type in so they can print it? Right now it allows me to type in it (in report view), but as soon as I click off the textbook to something else it wipes whatever I had just typed. Any solutions?

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,527
    You need a form, with all the text boxes you want.
    txtName
    txtCC
    etc.

    Then the query that runs the report will bring these items in as fields, and/or filters.
    select forms!frmRpt!txtName as Name, * from table

  3. #3
    nick404's Avatar
    nick404 is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    May 2015
    Location
    Wisconsin
    Posts
    352
    Great thank you!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 08-04-2014, 09:52 PM
  2. Replies: 3
    Last Post: 02-28-2014, 10:17 AM
  3. Replies: 5
    Last Post: 03-21-2013, 01:59 PM
  4. Replies: 3
    Last Post: 03-11-2013, 05:11 PM
  5. Help with allowing administrator access using user name
    By BiotechJen in forum Programming
    Replies: 4
    Last Post: 01-30-2013, 11:02 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums