Ladies & Gents ---

I have a form for entering several numeric values into a database, using a
Date as the Primary Key.

When the form starts up, I'd like to implicitly have the ">*" button pressed
on the form so the user gets a new, blank record the first time. It's a
little
too easy to just put in a date, and have erronious values from previous
entries
input.

Thankx in advance from The Big Gray Cat....

in the form load event add the following code
DoCmd.GoToRecord , , acNewRec


--
~Your Friend Chris
http://myvbastuff.blogspot.com/
thinking out loud


"Big Gray Cat" wrote:

> Ladies & Gents ---
>
> I have a form for entering several numeric values into a database, using a
> Date as the Primary Key.
>
> When the form starts up, I'd like to implicitly have the ">*" button pressed
> on the form so the user gets a new, blank record the first time. It's a
> little
> too easy to just put in a date, and have erronious values from previous
> entries
> input.
>
> Thankx in advance from The Big Gray Cat....
>