 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / October 2007subform - new record entry
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. 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.  SignatureAl 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." >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 [quoted text clipped - 3 lines] > of at the bottom? if so, how do i do this. > thanks in advance. thanks for your input al. not had chance to try this out yet but i think you have pointed me in the right direction. > ivanoddcat, > Not within that subform itself. [quoted text clipped - 11 lines] > > of at the bottom? if so, how do i do this. > > thanks in advance. 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. Signaturehth 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." > thanks for your input al. > not had chance to try this out yet but i think you have pointed me in the [quoted text clipped - 19 lines] >> > of at the bottom? if so, how do i do this. >> > thanks in advance. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.