open continuous form - shows 1st record not last..

[Guest]

How can I set continuous form to open showing top of recordset, rather than
bottom?
Switchboard manager opens to show empty new Add row, even when set to Open
in Edit mode. Can scroll up to top, but when open form right from database
window in a2003, opens form from top of recordset.
thx!

 

[Richnep]

How can I set continuous form to open showing top of recordset, rather than
bottom?
Switchboard manager opens to show empty new Add row, even when set to Open
in Edit mode. Can scroll up to top, but when open form right from database
window in a2003, opens form from top of recordset.
thx!

Set the forms recordsource to a query. Then use the query to sort the
records.

 

[Guest]

Set the forms recordsource to a query. Then use the query to sort the
records.

Tried that - it's not the sort order, but that on form open, it scrolls to
bottom of recordset as if to add a record, instead of top. I'd like it to
open at top of recordset.