Data base page setup

[garbogirl]

I am working on a rather lenghty database and would like to know how I can
set up my spreadsheet to take me to the next available line without scrolling
through the existing lines

 

[Duane Hookom]

garbogirl,
Are you sure you are working in Access? "spreadsheet" suggests Excel.

 

[garbogirl]

You're right.. spreadsheet wasn't the correct way to address this issue. My
data base is in access and I am just trying to input new data with out having
to scroll thru the data to get to the next line.

 

[Duane Hookom]

You shouldn't be allowing users to access your tables directly. You can add a
button on a form that moves to a new record if that is what you want. You can
use the code generated by the command button wizard in the On Open event of
the form.

 

[John W. Vinson]

I am working on a rather lenghty database and would like to know how I can
set up my spreadsheet to take me to the next available line without scrolling
through the existing lines

Not in a table or query datasheet, no. You can click on the *> "new record"
navigation button.

You *should* be doing all of your data entry using a Form, not directly in
Tables. On a Form you can set the form's Data Entry property to Yes if you
ONLY want to add new records, and not see any existing ones (you can use a
separate form for editing if you wish); or you can use the toolbox command
button "Record Operations" option to add a button to go to the blank new
record.