Discussion on:
Message 1 of 7
Default values for Access form
Actually, I can think of three different ways to do what you ask, but one way in particular probably answers your question most directly. FIRST, set up public variables for the "defaults" in question and initialize them (to blank, zero, etc.). SECOND, create After_Update event triggers such that the variables are populated as data is entered for each related field (this will also allow you to change the "default" by overtyping with new information). THIRD, create event triggers such that variable values are entered in the related fields when a new record is begun. Certain precautions could be taken in this last set of triggers to minimize the chance of partially completed records.
Posted by LKJCPA
24th Oct 2011

































