Go to new record on form load

[tmryan]

Is it possible to make the navigationbuttons go to a new form ">*" on Form_Load ?

Thanks Tim Ryan
PROGRESS Developer

 

[VBslammer]

I don't follow you, can you elaborate?

VBSlammer

 

[tmryan]

Let's say I have a table with 22 records in it. When I open up a form for entering/editing data, it opens up to the first record. I have to hit the NavigationButton that has a >* on it to go to a blank form (rec 23) - to enter a new record. I'd like that to occur on form load.

Thanks Tim Ryan
PROGRESS Developer

 

[Rolliee]

There is a docmd which brings in a new record. The wizard will show you the code. It is somethng like:

DoCmd.GoToRecord ,, acNewRecord

This could be triggered b y an onopenform event.

rollie@bwsys.net

 

[gusbrunston]

Hi Tim:

Rolliee's right; the exact DoCmd is:

DoCmd.GoToRecord , , acNewRec

Cheers, Gus Brunston An old PICKer, using Access2000. I manage

http://www.rentdex.com.

Suggestions welcome. padregus@attbi.com

 

[tmryan]

Thanks to both of you. I will try it out today. Tim Ryan
PROGRESS Developer