Results 1 to 6 of 6
  1. #1
    accessnewbie352 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    46

    Creating a Box to Enter Value - Form Created from a query


    I have a form whose recordsource is a query. I want to put a box on the form for the end-user to enter a % and then have the % be multiplied to a couple of fields. I know I can do the last part via a calculated field but I have having trouble adding in a box where the user can type in a value. How do I do this?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    An UNBOUND control will show the same value for all records. Do you need this user-entered value saved? Need field in table and then pull that field into the query.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    accessnewbie352 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    46
    No I don't necessary need the value saved. The purpose of the form is to see: "How much money would I have if the budget was increased by x%" where X% is what the user will enter. I need to create on the form a couple of texts that shows the difference between the money and the new amount if * by 1+X%.

    Are you saying the only way to do this is to create a table from the query and then add in a new field to this table and base my form from the table?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    No, can use an UNBOUND control and user can enter whatever they want. It just won't be saved anywhere. If the form displays multiple records, all will show the same value the user entered.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    accessnewbie352 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    46
    I created the unbound control but it is not allowing me to enter any values (typing icon | is blinking) but no values can be entered? Am i missing a step?

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Maybe the query is not editable. Can you edit any of the other data?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 09-27-2014, 09:48 AM
  2. Creating an Access Database to enter data
    By Doofus1 in forum Access
    Replies: 1
    Last Post: 08-17-2014, 06:33 PM
  3. Replies: 6
    Last Post: 04-16-2012, 01:05 AM
  4. Replies: 0
    Last Post: 11-30-2011, 02:01 PM
  5. Replies: 7
    Last Post: 02-25-2010, 12:32 PM

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