Results 1 to 4 of 4
  1. #1
    Byldavis is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2020
    Posts
    3

    Combining Columnar and Tabular formats in the same form

    I'm building a Quote database. It's similar to an invoice database with a header and a detail table.


    I'd like to create a form where the user can enter and continue to view the header data as they enter
    the detail data. I'd also like the tabular detail portion remain on the screen as more products are added.
    Is this even possible in Access?

    Thanks & regards,
    Bill Davis

  2. #2
    mike60smart is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    429
    Hi Bill

    Yes it can be managed by using Main Form & Sub Form layout

    Can you upload a zipped copy of your database?

  3. #3
    Byldavis is offline Novice
    Windows 10 Office 365
    Join Date
    Aug 2020
    Posts
    3

    QuoteDatabase

    OK, here it is.

    Thanks,
    Bill Davis
    Attached Files Attached Files

  4. #4
    mike60smart is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    429
    Hi Bill

    You need to setup your relationships as shown in the attached.

    The related QuoteID in the Subform now automatically populates when you add a new Detail record for the selected Quote #

    The Quote is in the Main Form with the Quote Details in the Child Subform
    Attached Files Attached Files

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

Similar Threads

  1. Tabular form
    By Jishnu Surendran in forum Forms
    Replies: 4
    Last Post: 02-25-2018, 12:09 PM
  2. Columnar Form - Multiple Entry
    By finfin in forum Forms
    Replies: 1
    Last Post: 10-15-2015, 02:01 AM
  3. Columnar Report with more than one column
    By Brandonc333 in forum Reports
    Replies: 8
    Last Post: 06-26-2013, 03:58 PM
  4. Change columnar report to Row
    By survivo01 in forum Forms
    Replies: 3
    Last Post: 11-02-2012, 02:24 PM
  5. Tabular Form
    By Evgeny in forum Forms
    Replies: 0
    Last Post: 04-26-2010, 08:39 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 - Senior Forums