Results 1 to 12 of 12

Thread: Access form search

Threaded View

  1. Mar 30th, 2005, 03:51 AM #1
    JamesBowtell
    JamesBowtell is offline

    Thread Starter
    Addicted Member
    Join Date
    Nov 2004
    Posts
    144

    Access form search

    Each time a search through the database and get to a certain record i get the following error message

    'Can't set value to NULL when checkbox property = FALSE'

    But i aintgot any checkboxes on my form


    can any one explain?

    Thanks

    James Bowtell

    ==========================================================
    UPDATE
    ==========================================================

    Hey guys

    Just a quick update

    I have three tables

    tbl_Appliance
    Appliance_No
    Serial_No
    Room_No
    Appliance_Type
    Appliance_Manufacturer
    Appliance_Model
    Appliance_Model

    tbl_ServiceHistory
    Service_ID
    Appliance_No
    PATTest_ID
    Service_Date

    tbl_PAT

    PATTest_ID
    PAT_Class
    PAT_FuseRating
    PAT_VisualCheck (Checkbox)
    PAT_insulation (Checkbox)
    PAT_EarthBond (Checkbox)
    PAT_Result
    PAT_Notes

    i have noticed that the above error appears when 1 of the 3 checkboxes are ticked

    does this help?
    Last edited by JamesBowtell; Mar 30th, 2005 at 04:01 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width