+ Reply to Thread
Results 1 to 2 of 2

Create form to handle multiple values for single record

  1. #1
    Registered User
    Join Date
    03-20-2013
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    37

    Create form to handle multiple values for single record

    I'm using Access 2010 to create a budget database. I'm trying to create a form so that users can enter a single record that can allow multiple values. For example, if someone goes to a supercenter such as Target or Walmart, they may purchase items that fall into multiple categories such as groceries, clothing, toys, etc. I'd like the form to accept a single record that includes date, check # (if applicable), etc., then allow the user to make multiple entries of amounts and expense categories, and have Access track the total amount for that specific record.

    Is this possible? And if so, how is it accomplished?

    Thanks in advance if anyone has any ideas.

    Doug

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,872

    Re: Create form to handle multiple values for single record

    You could do this with a form and subform. The form would hold your controls for

    RecordID PK
    Payee
    DateField
    CheckNr.
    other appropriate fields

    The subform would be bound to a different table with the following controls
    RecordID PK
    ExpenseID FK that would link to the PK in the other table/form
    category1
    category2
    category3
    etc.
    Miscellaneous or other category for unusual or not listed category
    Comments Field if desired.

    So, two tables and two forms with one being a subform.
    The total for each record would be calculated either on the form and/or in a query but not in the tables.

    Hope this gets you started in the right direction.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 07-31-2013, 09:46 AM
  2. Create a single record with total sum of sales
    By RaymonGompelman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2013, 11:03 AM
  3. [SOLVED] Open a new form, create new record based on current form / record
    By Cyclops in forum Access Tables & Databases
    Replies: 4
    Last Post: 01-28-2013, 06:36 PM
  4. Replies: 2
    Last Post: 07-21-2012, 08:36 AM
  5. create a list of single values from multiple values
    By Jordan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-03-2005, 07:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1