Results 1 to 2 of 2

Thread: Form for Checklist
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular schielrn's Avatar
    Join Date
    Apr 2007
    Location
    Cincinnati, Ohio
    Posts
    6,934
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Form for Checklist

    I am struggling figuring this out and thought it should be something simple. What I want to do is create a subform in a main form that is a checklist that needs to be marked as pass, fail or n/a. I have a table that based on the product they select will show the appropriate checklist items. The products are the 7 columns after SortOrder and depending on what product they want, I can get it to show only the applicable checklist categories and checklist items, but cannot figure out how to go about having the form have a radio button for pass, fail and n/a or even a dropdown box with those 3 values. I have searched the internet for an answer and haven't had much luck other than one series of youtube videos, but I couldn't get it to work.

    https://usbank-my.sharepoint.com/per...csf=1&e=ObKsG4


    My plan is to then write the record and selected pass/fail/na to this table and the recorded would be from the main form.

    https://usbank-my.sharepoint.com/per...csf=1&e=PKbBu9

    Maybe I am thinking about this wrong or setting it up incorrectly, but cannot figure out how to do this task.
    Last edited by schielrn; Aug 12th, 2019 at 03:32 PM.
    Always make a back up copy before trying new code, you never know what you might lose!


    - Posting guidelines, forum rules and terms of use

    -Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes

    "The world suffers a lot. Not because of the violence of bad people, but because of the silence of good people!"

  2. #2
    Board Regular
    Join Date
    Jun 2015
    Location
    Ontario, Canada
    Posts
    1,702
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Form for Checklist

    create a subform in a main form that is a checklist
    The main form is a check list? Then what is the subform for?
    The products are the 7 columns after SortOrder and depending on what product they want
    If you need to add a product, you have to add a field to your table? That indicates lack of normalization, which might be contributing to the issue. Radio (option) buttons have to be in a frame and obviously cannot be on a subform if that subform is continuous or datasheet. I find your description of what is and what's wanted somewhat confusing, and your links are to a SharePoint site?? Not sure how you expect anyone to be able to see that, but then again, I never learned much about SharePoint. That might explain why there's been over 200 views and no other replies.
    Tips for posting problems:
    1) "doesn't work" doesn't help. Post error message text/numbers and/or state what's happening.
    2) if posting code or sql, use code tags; specify on which code line errors occur, if applicable
    3) try to be specific; assume we know nothing about your issue - because we don't!

    Make all suggested changes in copies of your database or to its objects.

    "1 out of 1010 people understand binary. The other 1001 don't."

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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