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).