Form data entering

#1

When I open up the form to enter data it shows record 1.I must then select
the >* to add a new record. Some times I forget to do this and start
entering data into the first record before I realize what I am doing. How do
I get the form to automatically bring up the next blank record in order to
enter data? TIA

#2

In design mode, goto to the properties of the form.
In the events tab find load
Clcik to the far right on the ...
Choose code.

Put the followng 2 lines as the body of the code.

DoCmd.GoToRecord , , acLast
DoCmd.GoToRecord , , acNext

That will do it. Note this can not be tested by single stepping.

Good luck
Ira Solomon

On Sat, 1 Jan 2005 10:58:39 -0600, "Leon" <leon (AT) dillingham (DOT) net> wrote:

Quote:

When I open up the form to enter data it shows record 1.I must then select
the >* to add a new record. Some times I forget to do this and start
entering data into the first record before I realize what I am doing. How do
I get the form to automatically bring up the next blank record in order to
enter data? TIA

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Form data entering

comp.database.ms-access comp.database.ms-access

Form data entering - 01-01-2005 , 10:58 AM

Re: Form data entering - 01-04-2005 , 08:49 AM