+ Reply to Thread
Results 1 to 10 of 10

Ms access database, how to auto fill a form and how to amend it through the form

  1. #1
    Registered User
    Join Date
    08-31-2014
    Location
    London
    MS-Off Ver
    2013
    Posts
    21

    Red face Ms access database, how to auto fill a form and how to amend it through the form

    Hi

    I have a work MS Access database which my boss has asked me to enhanced. I am quite new to MS Access so would like people's input. The database has a form and a table and each record has a unique identifier. Users will go into the form and fill in details (sometimes some fields do not get updated) Once the user puts the details in, it gets saved into the table.

    Now here is the question. My boss has asked me to enhance the database so that users can retrieve the record using a form by doing a search on the identifier and then amend the fields which they have left off.

    So I need the database so somehow bring (or auto fill the details) that has already been updated and then enabled them to amend the details so the database needs to do the following

    - Users can retrieve a record by doing a search on the Identifier so the record of the identifier appears on the form
    - Users can amend the form and details
    - User saves and then table gets updated

    My database is very simple so I hope someone knows how to do this

    Thank you

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,130

    Re: Ms access database, how to auto fill a form and how to amend it through the form

    in a text box on the form header, say txtFind
    user enters a ID in the box , presses enter, in the afterupdate event of the box
    Please Login or Register  to view this content.
    then that record will show. Users can fill in fields.

  3. #3
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,143

    Re: Ms access database, how to auto fill a form and how to amend it through the form

    here is an easy to follow tutorial

    http://www.datapigtechnologies.com/f...tomfilter.html
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Registered User
    Join Date
    08-31-2014
    Location
    London
    MS-Off Ver
    2013
    Posts
    21

    Re: Ms access database, how to auto fill a form and how to amend it through the form

    Hi Alansidman

    Thank you the video made sense and I followed it. However I notice when I go into form and go to record source to put the criteria in, the fields have not been selected which means the form I am trying to pre-populate are subforms. Do you have an example of how I can do this by using sub forms?

  5. #5
    Registered User
    Join Date
    08-31-2014
    Location
    London
    MS-Off Ver
    2013
    Posts
    21

    Re: Ms access database, how to auto fill a form and how to amend it through the form

    Hi Alansidman,

    My sub forms have the fields that need to be populated. The example given was for the main form. Do you know what I need to tweak? I follow the example you had sent me it was such a good video but when I got to the part to select the ID the fields didn't populate. I think it's to do with the fact I created a sub form. Any ideas how I can overcome this?

  6. #6
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,143

    Re: Ms access database, how to auto fill a form and how to amend it through the form

    Suggest you upload your FB with a small sample of non confidential data and specie example of what you want to happen. Run a compact on the FB and zip it before attaching

  7. #7
    Registered User
    Join Date
    08-31-2014
    Location
    London
    MS-Off Ver
    2013
    Posts
    21

    Re: Ms access database, how to auto fill a form and how to amend it through the form

    Hi alansidman

    Thanks for getting back to me. I've loaded the sample of the database attached

    Update existing Document - That is the drop down box I have created so if the user wants to recall an entry they select the ID and in theory the sub forms will populate what has been saved in data table
    (called Documents) and allows users to amend the details in the subforms if they wish to

    Sub Forms (preliminary, Red Flags, High Level, Cohorts, Features, Commentary, etc) are the tabs what I would like it automatically update when user selects the update existing document)

    db_example.zip

    Hope this makes sense

  8. #8
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,143

    Re: Ms access database, how to auto fill a form and how to amend it through the form

    See attached. I followed Mike Alexander's video solution as shown in the post I recommended above. I changed the property option for the form for Data Entry to No. This last step is imperative for this to work.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    08-31-2014
    Location
    London
    MS-Off Ver
    2013
    Posts
    21

    Re: Ms access database, how to auto fill a form and how to amend it through the form

    Hi Alansidman

    Thank you so much. So you just changed the form property. I was trying to work out why but now it makes sense

    You have saved me!!!

  10. #10
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Version 2211 (Build 15813.20002) Win 11 Home 64 Bit
    Posts
    22,143

    Re: Ms access database, how to auto fill a form and how to amend it through the form

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel form to auto add into an access database.
    By henryc123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-15-2013, 10:37 PM
  2. Need Macro to Fill Database with Form Info
    By Melvinrobb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-30-2013, 02:14 PM
  3. [SOLVED] Auto Fill-out Form
    By znalron@yahoo.com in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-14-2012, 10:07 AM
  4. Auto Fill Web Form using Excel User Form
    By vandanavai in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2008, 02:26 AM
  5. Excel Form into Access Database
    By RecRic in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-17-2007, 06:42 AM
  6. Amend a record in a database with a form.
    By Jwalker in forum Excel General
    Replies: 0
    Last Post: 09-23-2006, 05:16 PM
  7. Replies: 1
    Last Post: 08-26-2005, 05:05 AM
  8. [SOLVED] Form/template to pull information from access database
    By jwr in forum Excel General
    Replies: 1
    Last Post: 08-24-2005, 11:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1