Results 1 to 2 of 2
  1. #1
    spidge32 is offline Advanced Beginner
    Windows 10 Access 2013 32bit
    Join Date
    Jul 2021
    Posts
    58

    Fields on Form one to Many relationship

    I have a sub form which has a one to many relationship. All the Combo Boxes select data correctly, but if anyone of the Combo Boxes is left blank the record is not saved.
    I have checked the fields in the table and as not required. there are 3 Combo Boxes on the Form.
    Does anyone know where to look further?

    The error is as follows

    You tried to assign the Null value to a variable that is not a Variant data type. (Error 3162)


    The Combo Box updates a normal data entry field

    All of the records without these 3 fields populated are no longer seen on the form.



    I have imported data from an excel spreadsheet, that is why there are blank fields, I intend to enter these fields as required. The table has 18000+ records of
    possibly 30% have missing data in those 3 fields.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Make sure your fields allow nulls,
    and set a default value,if null, to prevent this error.

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

Similar Threads

  1. Replies: 20
    Last Post: 08-31-2020, 01:18 AM
  2. Replies: 2
    Last Post: 04-21-2018, 06:11 AM
  3. Building relationship between similar fields
    By SamuelOu in forum Access
    Replies: 4
    Last Post: 02-12-2015, 04:33 PM
  4. Replies: 3
    Last Post: 08-07-2013, 10:25 PM
  5. relationship between fields
    By mandiahk in forum Access
    Replies: 9
    Last Post: 04-09-2013, 01:43 PM

Tags for this Thread

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