Can i set my form default to last entered record

[patentinv]

Hello, I have a program/database that I'm building in Access 2003, It has new client/bid entry form that has many text boxes for instance: Client, address, Phone numbers, Date etc. These text boxes are actually populating the same text fields in the PrimaryBid_Master form.

My question is every time I fill out the client entry new bid form and then exit to the PrimaryBid _Master form it defaults to the very first record entered, and I would like it to default to the last record entered, The record I just got done entering into the new client bid form, this would save me from having to filter/find it every time I enter a new bid/client, Is this possible and if so Can you describe to me how I can have my program do this?


Thanks--Chuck I really appreciate any help/suggestions.

 

[ghudson]

RecordsetClone.MoveLast

Will take you to the last record in the record set. Stick that in the forms OnOpen event.

 

[Oldsoftboss]

In the forms Load event put

DoCmd.GoToRecord , , acLast

Dave

 

[Pat Hartman]

When you open one form from another, use the WHERE argument of the OpenForm Method to provide the necessary filter.