Results 1 to 4 of 4
  1. #1
    Pam Buckner is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    12

    Button to Create New Record


    I would like to create a button with a macro that will bring up a blank form to create a new record (as opposed to going directly to the datasheet table). There are options to Save a Record, Refresh a Record, Search for A Record, Delete a Record and Show All Records, but I don't see a macro to create a new record. Can this be done? If not through a macro, then code?

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    First, all interaction with the database should be through forms. Users should never have access to the tables.

    To do what you want, you just need to create a form bound to the table you want. Then, while in design view of the form go to the property sheet-->data tab-->Data Entry

    You just need to change the data entry property from no to yes. What this does is when you open the form in form view, it opens to a blank record ready for you to enter your data.

  3. #3
    Pam Buckner is offline Novice
    Windows XP Access 2007
    Join Date
    Mar 2010
    Posts
    12
    Awesome! That worked like a charm

  4. #4
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    Glad that worked for you. Good luck with your database.

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

Similar Threads

  1. Replies: 4
    Last Post: 07-22-2011, 12:52 PM
  2. Replies: 10
    Last Post: 03-21-2011, 02:46 PM
  3. Create an RDP link button on my form
    By BDP in forum Access
    Replies: 1
    Last Post: 09-14-2010, 02:49 PM
  4. Replies: 6
    Last Post: 02-09-2010, 07:53 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