Limit Subform to Data Entry

[AJ]

Excuse my lack of expertise...

I am trying somthing that I believe to be simple...

I have a subform that opens from a main form... I would like this subform to
open for Data Entry only.
I have toggled the Data Entry tag, and the subform behaves properly when
loaded on its own... but when I link to it via the button on the main form,
it loads the earliest record and requires you to scroll through until a new
record is available.

I dont mind the user being able to see the other records... but for
simplicity I would prefer to see the blank record show up first.

Any suggestions?
Simple solutions are typically the toughest to find.

Thanks

 

[Al Campagna]

AJ,
Here's an old trick... from an old trick. :-D
Create a new subform that's only one record high, and place it just
above your current subform.
Actually you can use a copy of the old subform, except you'll remove any
Headers. Footers, Nav Buttons, etc...
Make that subform DataEntry only, and access it instead of the old
subform.

Your old subform can be disabled, so no one can make any changes there,
and you could sort it DOC (Date of Creation) descending. This would force
any new records added by the new form to appear to just drop down into your
old records.

Now it "appears" as just one subform, where new records are added at the
top. Requery the old subform after every record entry in the new one.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."