Results 1 to 5 of 5
  1. #1
    nasps is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Oct 2019
    Posts
    8

    Table based form


    Hello

    I have a simple table with 3 fields.
    I've created a form based on that table so that every data I insert in the form fields are record.
    It works fine when I type all the data in the form. Works a charm.
    However, I've predefined a valu in one of the fields, meaning that I don't input data as it is already there. As I save the record the table gets filled with all the fields except the one that was with a predefined value (leaves the table field blank).
    I made some msgbox to check if all the fields have the values and not one is blank so I don't understand why it's not writen in the table.

    Any ideas?
    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    does the table have DEFAULT VALUE?
    does the text box in the form have DEFAULT VALUE? (prefered)



  3. #3
    nasps is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Oct 2019
    Posts
    8
    Quote Originally Posted by ranman256 View Post
    does the table have DEFAULT VALUE?
    does the text box in the form have DEFAULT VALUE? (prefered)

    No to the first question
    Yes to the second as I can well display the info I want to be on that text box to be record on the table field. No record of that value, though

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,938
    e
    xcept the one that was with a predefined value (leaves the table field blank).
    can you confirm that this control has its control source set to the correct table field

  5. #5
    nasps is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Oct 2019
    Posts
    8
    Touché

    Wrongly copied the Default Value on the control field to the Control Source!
    Thanks a lot...


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

Similar Threads

  1. Replies: 5
    Last Post: 06-25-2017, 01:24 PM
  2. Replies: 3
    Last Post: 06-04-2015, 09:48 AM
  3. Replies: 7
    Last Post: 09-15-2014, 11:55 AM
  4. Replies: 3
    Last Post: 06-18-2014, 10:40 AM
  5. Replies: 3
    Last Post: 05-02-2014, 09:02 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