Results 1 to 2 of 2
  1. #1
    aaid is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    1

    Auto-fill field not saving to table

    Hello!



    I hope someone can help with this:

    In the form, there is a field that gets filled in automatically by what is entered into two other fields on that form.

    The information that is being automatically generated in that field is not saving to the table.

    Example:

    Field 1: Meeting Type
    Field 2: Meeting Year
    Field 3: Auto-fill field (starts out blank)

    Field 1: I choose "Annual Meeting" for the meeting type (this puts AM into Field 3)
    Field 2: I choose "2010" for the meeting year (this adds 10 into Field 3)
    Field 3: "AM10" is now what shows in the field

    I save the data base. I go look at the table and there is nothing in the Field 3 column, when there should be "AM10."

    Any ideas about how to get it to save that info in the table?

    Thank you!

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows XP Access 2002
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    What method are you using to "autofill" this field? I suppose you already know that it is not a good practice to save calculated fields?

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

Similar Threads

  1. Auto fill a field from multiple lookup
    By shahemaan in forum Forms
    Replies: 4
    Last Post: 06-13-2014, 04:00 PM
  2. Auto-fill in datasheet
    By Terence in forum Database Design
    Replies: 2
    Last Post: 03-18-2010, 03:42 PM
  3. Auto fill a table?
    By newtoAccess in forum Access
    Replies: 3
    Last Post: 11-21-2009, 08:21 PM
  4. Auto Populated Field not Saving to Table
    By EstesExpress in forum Forms
    Replies: 4
    Last Post: 10-09-2009, 03:33 AM
  5. Replies: 1
    Last Post: 03-08-2009, 01:50 PM

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