[AccessD] On Form Opening

Thanks Mark,
At my age, I tend to overlook some simple things, but I really didn't think there was anything simple about Access.

Jim

-------------- Original message -------------- 
From: "Mark A Matte" <markamatte at hotmail.com> 

> 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 
> >To: Access Developers discussion and problem 
> >solving 
> >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 
> 
> 
> -- 
> AccessD mailing list 
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd 
> Website: http://www.databaseadvisors.com