Bill, Just a guess from the info you provided. It sounds like you have a
form that is set to continuous or datasheet view and that forms uses some
sort of filter/criteria query as its recordsource. If so it seems you may be
using a parameter when you open the form, that moves the focus to the last
record or a new record. It works fine when only a few records are returned
by your filter, but when more records are returned then what will fit on the
screen the form is scrolled down. If this is the case will either have to
resize the form to fit the data or not move the focus to a new or last
record. My guess is you may be using something like this:
DoCmd.OpenForm "YourForm"
DoCmd.GoToRecord , , acNewRec (or acLast)
You can remove this if this is the case or replace it with acFirst
If this doesn't do it post back with more info/details.
--
Reggie
----------
"Bill Strass" <wi******************@hotmail.com> wrote in message
news:b6**************************@posting.google.c om...
I don't know why, but sometimes a form will scroll down a bit when the
form is opened. User then has to scroll up to view the beginning
(top) of the form.
Thanks in advance for any suggestions.
