Results 1 to 6 of 6
  1. #1
    HansBades is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    85

    Form Field Required


    I have a combobox in a form tied to a table field. The table field is not configured to be required. But the form requires this field to be entered or else it won't process the record. Any ideas how I can fix this? Thanks.

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,792
    There is probably code behind the form that is enforcing the requirement if the restraint is not coming from the table. Look at the Update events for the form and the control, or post a zipped db copy.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    HansBades is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Dec 2021
    Posts
    85
    There is no code behind the form that I entered. I am not sure why this is happening. I have a form of workorders that contains a subform indicating the different parts (skus) needed for the particular workorder. Each sku part requires an approval code, but only some parts require an approval explanation. But the form is acting as if the approval explanation field is required for every record. Could it be something with my relationships?

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,722
    Sure it could be a number of things, but we know nothing of the application.
    Can you post a copy of the database with enough info to highlight the issue?

    Did you create the database/application?

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    What is the nature of 'acting as if the approval explanation field is required' - error message?

    Is there anything in ValidationRule property?

    To provide your db for analysis, follow instructions at bottom of my post.
    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.

  6. #6
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,792
    If this is on a subform then yes, it could be a relationship thing if you're trying to move off of the subform record. The exact wording of the message would help as June7 wrote. Or post a zipped db cop.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 5
    Last Post: 08-14-2018, 11:59 AM
  2. Making Field Required on a Form
    By KBNETGUY in forum Programming
    Replies: 3
    Last Post: 04-12-2018, 10:45 AM
  3. Field required in Form
    By vugar in forum Forms
    Replies: 7
    Last Post: 10-21-2015, 07:45 AM
  4. Replies: 4
    Last Post: 11-04-2014, 07:35 PM
  5. Replies: 1
    Last Post: 12-07-2012, 02:14 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