Decending Order Existng Rec but open blank form 2

[houstonbill]

Have my form set to open so the ID # is in descending order with the last completed order ID record appearing. Hopefully this is not too dumb of a question but I would like to have the user open up a blank form while keeping all the other records available should they need to search through them.

 

[PHV]

Perhaps this in the Load event procedure of the form ?
DoCmd.GoToRecord , , acNewRec

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

How are ya houstonbill . . .

Also have a look at the forms [blue]Data Entry[/blue] property . . .

See Ya! . . . . . .

 

[houstonbill]

Like I said, I felt very dumb asking the question but you gave me the direction that I needed. Thanks for your help.