Try this:
'// Place this Code in your Forms AfterUpdate Event
Private Sub Form_AfterUpdate()
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
'// For every Text Box you want to Carry Foward to the new record put
Carry ) in it's Tag Properties
HTH.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
Behalf Of Crosier, Dawn
Sent: Wednesday, October 12, 2005 8:08 PM
To: [email protected]
Subject: RE: [ms_access] Re: auto default values
You could program an Unbound form and have the information from the
previous record displayed, and then force the users to make the
necessary changes to make the record unique.
Maybe
http://www.rogersaccesslibrary.com/download3.asp?SampleName=Unbound.mdb
will help.
Dawn Crosier
Application Specialist
"Education Lasts a Lifetime"
This message was posted to a newsgroup. Please post replies and
questions to the group so that others can learn as well.
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Carl Vogt
Sent: Tuesday, October 11, 2005 7:53 PM
To: [email protected]
Subject: [ms_access] Re: auto default values
Thanks,for the tips, would have liked to do it automaticaly but the
CTL+' will do the trick for now
Thanks again for the help
Carl
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> 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/
