Hopefully this bit of code will help:
Carry the Value of a Textbox Forward to a New Record
Private Sub Form_AfterUpdate()
'For every Text Box you want to Carry Foward to the new record put 'Carry'
in it's Tag Properties
Dim ctl As Control
For Each ctl In Screen.ActiveForm.Controls
If ctl.Tag = "Carry" Then
ctl.DefaultValue = """" & ctl.Value & """"
End If
Next
End Sub
Dawn Crosier
Microsoft Word MVP
"Education Lasts a Lifetime"
This message is posted to a newsgroup. Please post replies and questions to
the newsgroup so that others can learn as well.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Harold Williams
Sent: Monday, February 05, 2007 7:43 PM
To: [email protected]
Subject: [ms_access] form retain date
Hope I haven't asked this question here before. I didn't see how to
check what I have posted.
I am entering dates, ticket numbers, and other data into a form that I
have created based on a query. (Access 2000)
Five to eight of the tickets have the same date. How do I get the form
to carry the last date entered over to the next record? Then when the
date needs to be changed I could just type in the new date.
Thanks,
Harold
Yahoo! Groups Links
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.432 / Virus Database: 268.17.26/670 - Release Date: 2/5/2007
2:04 PM
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.441 / Virus Database: 268.18.1/690 - Release Date: 2/16/2007
2:25 PM
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ms_access/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
