Results 1 to 4 of 4
  1. #1
    CoffeeFunnel is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    12

    Form Creating Record...Not Sure How

    Hello Forum,



    I've always learned so much from these forums. And, I have another issue. I've inherited a small db tool and I'm okay with access, so i'm very puzzled because I can't figure out how a form is creating a record. I'm use to just using SQL commands in VBA, prompted by an event like a button push. But, I think I'm working with a data-bound form; but an unsure of the mechanism and where that mechanism is configured.

    I added a new field, included that field in the form's record source, and added another invisible textbox bound to the new field through the control source property; the invisible textbox is explained below.

    The way it behaves is, after a list box is changed; then a record is created. There are some invisible text boxes, that I made visible. The invisible text boxes are record columns within the table that the form is creating records for. So, the primary key box says (New) when the form opens, and the after the listbox is changed, the primary key appears along with all of the other fields, instead of the one I created. I checked the recordsource table, and my field is not updated.

    Any ideas?

    Thanks,
    CoffeeFunnel

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    If the form has a table in its Record Source property, and controls (like textboxes) have fields in their Control Source property, the form is bound and changes to the form will be reflected in the table. It's actually the most common method. More here:

    http://www.baldyweb.com/BoundUnbound.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    CoffeeFunnel is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    12
    Ahhh, thank you. You are correct. I forgot to set the recordsource property of the new textbox. Thank you.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Creating a record lookup form
    By joecamel9166 in forum Access
    Replies: 3
    Last Post: 05-23-2016, 01:34 PM
  2. Replies: 3
    Last Post: 04-18-2014, 12:20 PM
  3. Replies: 21
    Last Post: 08-05-2013, 06:23 AM
  4. Replies: 3
    Last Post: 07-30-2013, 10:54 AM
  5. Have a form look up field when creating a record
    By mattmurdock in forum Forms
    Replies: 1
    Last Post: 06-28-2012, 01:40 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