Home  |   French  |   About  |   Search  | mvps.org  

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

In Memoriam

Terms of Use


VB Petition

Forms: Carry current value of a control to new records

Author(s)
Dev Ashish

(Q)    How do I carry forward the current value of a control so that it's automatically entered for all new records?

(A)    To use the curent control value for new records, you need to assign it to the defaultvalue of the control. For example something like

'******** Code Start **********
    const cQuote=""""    'Thats two quotes
    me!Control.DefaultValue = cQuote & me!Control.Value & cQuote
'******** Code End **********

    would carry the current value of the control forward if you place this code behind a command button to conditionally run it.


© 1998-2010, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer