+ Reply to Thread
Results 1 to 3 of 3

Adding new record to existing database table with a form

  1. #1
    Registered User
    Join Date
    03-22-2016
    Location
    USA
    MS-Off Ver
    Office: Office 13 Home: Office 16
    Posts
    22

    Adding new record to existing database table with a form

    I'm building a database that logs and tracks inbound shipping containers and I'm trying to build a form to add new containers to the main table for display in the summary tab of the dashboard. The issue I'm running into is that whenever I click the "add new" button it opens the form with data from the table pre-filled in the boxes. How do I make it so the form opens blank and when I click the "Save/Update" button to add the new record it adds the record in sequence instead of somewhere in the middle?

    It's worth mentioning that there are some 350 records already in the database so finding one that's out of place takes some time.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Adding new record to existing database table with a form

    On the Data tab of the form's property sheet set Data Entry to Yes.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    03-22-2016
    Location
    USA
    MS-Off Ver
    Office: Office 13 Home: Office 16
    Posts
    22

    Re: Adding new record to existing database table with a form

    Thanks Norie, that did the trick. I know it's probably a silly question, but I'm still pretty new to Access, is it possible to specify that in the event there is a selection in a subform on the dashboard, that, that containers data be populated into the form?

+ 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. Re-populate User Form from the database record
    By henryBukowski in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-12-2015, 04:51 PM
  2. Last record is not adding to database
    By ramserp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2009, 08:43 AM
  3. 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
  4. Replies: 3
    Last Post: 07-30-2005, 11:05 PM

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