<div>
 &lt;How can i link to another form via a button&gt;<br />
<br />
Private Sub btnOpenForm_Click()<br />
DoCmd.OpenForm &quot;frmName&quot;, acNormal, , , acFormAdd<br />
End Sub<br />
<br />
<br />
&lt;&nbsp;how can i disable the add new default feature when scrolling through forms? &gt;<br />
<br />
Go to Form property -&gt; Data Tab -&gt; Set Allow Additions to &quot;No&quot;<br />
<br />
Sincerely,<br />
Ed
</div>


<How can i link to another form via a button>

Private Sub btnOpenForm_Click()
DoCmd.OpenForm "frmName", acNormal, , , acFormAdd
End Sub


< how can i disable the add new default feature when scrolling through forms? >

Go to Form property -> Data Tab -> Set Allow Additions to "No"

Sincerely,
Ed

<div>
can i do this with property click or something without vba code?<br />
<br />
Private Sub btnOpenForm_Click()<br />
DoCmd.OpenForm &quot;frmName&quot;, acNormal, , , acFormAdd<br />
End Sub<br />

</div>


can i do this with property click or something without vba code?

Private Sub btnOpenForm_Click()
DoCmd.OpenForm "frmName", acNormal, , , acFormAdd
End Sub


<div>
<div class="content wysiwyg-content">
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.<br />
<br />
How can i link to another form via a button and how can i disable the add new default feature when scrolling through forms?
</div>
</div>


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?

button add new

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.