Results 1 to 4 of 4
  1. #1
    Akchayan is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Aug 2022
    Posts
    102

    Report which is created with form inputs

    Basis:


    I have a form which should create offers.
    The offer should look like this:
    Click image for larger version. 

Name:	Screenshot 2022-11-10 150920.png 
Views:	15 
Size:	143.2 KB 
ID:	49077
    I have also implemented this then:
    Form:
    Click image for larger version. 

Name:	Screenshot 2022-11-10 151357.png 
Views:	15 
Size:	25.4 KB 
ID:	49075
    Report:
    Click image for larger version. 

Name:	Screenshot 2022-11-10 151213.png 
Views:	15 
Size:	34.4 KB 
ID:	49078

    The problem I have is that the user does not always need all 5 input options, I have solved this so that if the user only makes 3 inputs, the remaining 2 fields in the report are hidden. The problem that arises is that there is too big a gap between the different stages.
    This would then look like this:
    Click image for larger version. 

Name:	Screenshot 2022-11-10 151927.png 
Views:	15 
Size:	32.2 KB 
ID:	49076
    If anyone has a suggestion for a solution, I would be open to solving it differently and if there is any confusion as to what I mean, please ask.


    Thanks for the help!

    And i tried it with a continuous form but i don't know how to mimic it for the report then.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Only bring in to the report the inputs needed?
    I would not have separate sections.

    Just one section that repeats. You decide the order and the value of the controls in each section.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    xps35's Avatar
    xps35 is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jun 2022
    Location
    Schiedam, NL
    Posts
    229
    Build the report based on a table (or tables). The form should also be based on that table(s). That is what databases are all about: tables.
    Groeten,

    Peter

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,858
    Really looks like your DB is not normalised?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

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

Similar Threads

  1. Replies: 0
    Last Post: 07-18-2016, 10:41 AM
  2. Replies: 9
    Last Post: 10-02-2015, 12:19 PM
  3. Report And Subreport multiple user inputs
    By JGrots in forum Reports
    Replies: 16
    Last Post: 01-29-2013, 01:58 PM
  4. Using user inputs as variables in a query/report?
    By cheese9799 in forum Reports
    Replies: 3
    Last Post: 03-01-2011, 11:30 AM
  5. selecting Sub-Form data from two inputs
    By techexpressinc in forum Queries
    Replies: 19
    Last Post: 12-03-2010, 11:03 AM

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