Mimic built-in 'New Record' Button

[jjturner]

Hello,

Using Access 97, I've replaced the built-in navigation buttons with my own, but I can't figure out how to mimic the recordset behavior of the NEW button. Essentially, I don't want the form to filter when the user clicks my NEW button, which it does currently and is the difference between my NEW and the built-in NEW.

It's probably s.t. simple I'm missing, but any help would be most appreciated.

Thanks,
John

 

[Rich]

DoCmd.GoToRecord , , acNewRec

 

[jjturner]

That's what I'm using, but that filters the underlying recordset so that I can't move Previous or First . . .

 

[ddmcn]

Wizards

John,

I know this flies in the face of logic...but do you use the wizards to build your forms? You can add a button with the toolbox and when the wizard comes up choose record operations. The first option there is Add New Record...

that should work.

 

[ghudson]

Why don't you turn the filtering off?

Me.FilterOn = False
DoCmd.GoToRecord , , acNewRec

HTH

 

[jjturner]

ghudson -

That's it! I hadn't used the FilterOn property before, I guess that would be too obvious for me!

Many Thanks,
Joh