Can i set my form default to last entered record 2

[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 number, 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--I really appreciate any help/suggestion

 

[MajP]

The simplest solution would be to set the sort order of the form on an autonumber field to descending. The sort order will then be in the reverse order they were entered.

 

[Patentinv]

Hi MajP,
I'm not able to find how to do this, Can you guide to where this option is available or how to accomplish this.

Thanks I appreciate your help.

 

[TheAceMan1]

How are ya Patentinv . . . . .

In the [blue]OnLoad[/blue] event of the [blue]Master[/blue] form, try this:

[blue]   Me.Recordset.MoveLast[/blue]

See Ya! . . . . . .

 

[Patentinv]

Hi Aceman1,
I'm doing pretty good, How have you been?
I don't know what I would do with out you guys.
Works perfect.


Thanks allot, I really appreciate your time and help.