button add new

[jagguy]

In acces 2007 I want to create a form where i scroll through records but the only way to edit or add a new record is to click on a button and go to another form.



How can i link to another form via a button and how can i disable the add new default feature when scrolling through forms?

[timmy]

i think i know what you want to do... try this

open the property sheet of a text box, on the data tab set locked to yes.
then create a button and add this behind it:

Function 
ButtonName___On_Click()
    DoCmd.GoToRecord acForm, "FormName", acNewRec
    DoCmd.SetProperty "TextBoxName", acPropertyLocked, "No"
End Function

you have to enter a DoCmd.SetProperty line for every text box.