[AccessD] On Form Opening

Jim,

I think if you set the form's "DATA ENTRY" property to YES...you will get 
the effect you are looking for.

Or if you want them to be able to navigate to previous records...you can put 
the following code in the "ON OPEN" event:
    DoCmd.GoToRecord , , acNewRec

Hope it helps,

Mark A. Matte



>From: jimjih at comcast.net
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>Subject: [AccessD] On Form Opening
>Date: Wed, 01 Mar 2006 18:00:00 +0000
>
>Hi all,
>I am quite new at working with Access, having learned what little I know 
>from a very good book, and only because an accounting client needed 
>something that QuickBooks couldn't do.
>
>My question is this:  I have several forms used to input data such as 
>Employees, Sub-Contractors, Customers, Delivery Tickets, etc.  When the 
>form is opened all fields are populated by data from the first item in that 
>particular table.  Is it possible to have all fields blank upon opening.  
>Have not been able to find an answer in the books.  I figured a workaround, 
>but it involves a lot of work.
>
>Also looked at the forms in the Northwind sample program, and their forms 
>do the same thing.
>Is it possible?
>
>Thanks,
>
>Jim Holbrook
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com