By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 900 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

Setting a default equal to the last value entered

P: n/a
I am trying to set a control to equal the last value entered for that control on the previous form. In other words: I have a control called HullNumber, which will remain constant for approximately 25 forms and then change to a new value. It is a necessary control for my relationships to work but it sure would be nice not to have to enter all of that text each time I enter a new record. Help me please.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Put the following code in the AfterUpdate event of your HullNumber control:

Me!HullNumber.Default = Me!HullNumber

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Glen Welsh via AccessMonster.com" <fo***@AccessMonster.com> wrote in
message news:33******************************@AccessMonste r.com...
I am trying to set a control to equal the last value entered for that control on the previous form. In other words: I have a control called
HullNumber, which will remain constant for approximately 25 forms and then
change to a new value. It is a necessary control for my relationships to
work but it sure would be nice not to have to enter all of that text each
time I enter a new record. Help me please.
--
Message posted via http://www.accessmonster.com

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.