<div>
Try this on Form Open event<br />
<br />
Dim rs As DAO.Recordset<br />
Set rs = Me.Recordset<br />
rs.FindFirst &quot;[Yard] Is Null&quot;
</div>


Try this on Form Open event

Dim rs As DAO.Recordset
Set rs = Me.Recordset
rs.FindFirst "[Yard] Is Null"

<div>
Remember, Date is an Access function and should never be used as a table, field, or variable name. &nbsp;If you absolutely have to, remember is must always be surrrounded by brackets when you make reference to it in a query or a module.
</div>


Remember, Date is an Access function and should never be used as a table, field, or variable name.  If you absolutely have to, remember is must always be surrrounded by brackets when you make reference to it in a query or a module.

<div>
<div class="content wysiwyg-content">
I have a table that lists all the days of the year with fields: Date and Yards. &nbsp;The idea is to enter a number of yards for each day of the year.<br />
I have a form (in datasheet view) that allows the user to enter the number of yards for each date. &nbsp;Right now - when the form/datasheet opens - it goes automatically to 1/1/2006 (because that is the first record of the table). &nbsp;What function/event can I use so that the form will open and find the first null value in the Yards field? &nbsp;(avoiding the scrolling to the next empty record).
</div>
</div>


I have a table that lists all the days of the year with fields: Date and Yards.  The idea is to enter a number of yards for each day of the year.
I have a form (in datasheet view) that allows the user to enter the number of yards for each date.  Right now - when the form/datasheet opens - it goes automatically to 1/1/2006 (because that is the first record of the table).  What function/event can I use so that the form will open and find the first null value in the Yards field?  (avoiding the scrolling to the next empty record).

Goto first Null Record

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.