Results 1 to 2 of 2
  1. 02-07-2012, 09:17 AM #1
    akhlaq768
    akhlaq768 is offline Novice
    Windows 2K Access 2002
    Join Date
    Feb 2012
    Posts
    14

    Default form view on startup


    i have created a form in access for users to enter data into...

    when the form is loaded is shows the 1st record from the dataset. is there anyway to default it to a blank new row?
    Reply With Quote Reply With Quote
  2. 02-07-2012, 09:24 AM #2
    R_Badger
    R_Badger is offline Knows a few tricks
    Windows XP Access 2003
    Join Date
    Feb 2012
    Location
    Suffolk, UK
    Posts
    262
    The way to use VB is

    Docmd.openform "Formname", acnormal, , , acformadd

    To do it via a macro

    at the bottom of the screen with your openform action selected change the Data Mode to Add

    I hope that helps
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. startup view
    By Canaglia in forum Database Design
    Replies: 5
    Last Post: 11-03-2011, 10:23 AM
  2. Default View from Switchboard
    By JRINC in forum Forms
    Replies: 3
    Last Post: 10-12-2011, 01:34 PM
  3. Programmatically change default switchboard at startup?
    By romeo_echo in forum Programming
    Replies: 4
    Last Post: 08-05-2011, 11:45 AM
  4. How do I set a form as the default start up view?
    By Vic Blake in forum Forms
    Replies: 3
    Last Post: 02-22-2011, 04:50 PM
  5. Unable to view objects in (startup) Form
    By sdondeti in forum Forms
    Replies: 0
    Last Post: 11-10-2009, 04:04 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums