subform - new record entry

[ivanoddcat]

i have a form called clients and a subform called history. the subform is
continuous and shows the previous 6 records. when i want to add a new record
to the subform i click on the >* and type away as usual. my question is :
is it possible to have the new record >* at the top of the subform instead
of at the bottom? if so, how do i do this.
thanks in advance.

 

[Al Campagna]

ivanoddcat,
Not within that subform itself.
You can add another "one line" subform, at the top of your regular
subform. That subform would be set to DataEntry = Yes... New records
only... no browse/delete/...etc.
After entering a new record in the one line subform... Requery your old
subform, and the new record should appear there.

 

[ivanoddcat]

thanks for your input al.
not had chance to try this out yet but i think you have pointed me in the
right direction.

 

[Al Campagna]

Ivan,
Well, I've never had occaision to use that method before, but it
certainly makes sense, and I've seen it suggested several time before.
Good luck.

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