 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / May 2008Default entry same as previous form
I am running Access 2000 on Windows XP. Is it possible to open a form and have the default entry as the same as in the on the previous form. I know once in the form I can press Ctrl' to achieve this. In effect what I am asking is is it possible to program the same effect as Ctrl' onto a field as the form is loaded / opened / scrolled onto. Thank you. Mellstock, Use the DefaultValue property of your field. Private Sub SomeText_AfterUpdate() SomeText.DefaultValue = " ' " & SomeText & " ' " End Sub (I've added spaces between the qoutes for clarity... remove then in your code) If you enter "Smith" in the field, Smith will be the default value for all new records... until you type manually type another text value in SomeText.  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." >I am running Access 2000 on Windows XP. Is it possible to open a form > and have the default entry as the same as in the on the previous form. [quoted text clipped - 6 lines] > > Thank you. Jan Baird is out of the country until September 20. Every effort will be made to respond to messages, but please be patient. Mellstock, Ooops... forgot my signature on my first post... 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." >I am running Access 2000 on Windows XP. Is it possible to open a form > and have the default entry as the same as in the on the previous form. [quoted text clipped - 6 lines] > > Thank you. Jan Baird is out of the country until September 20. Every effort will be made to respond to messages, but please be patient. Jan Baird is out of the country until September 20. Every effort will be made to respond to messages, but please be patient. |
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.