View Single Post
  #3  
Old February 22nd, 2010, 09:51 PM posted to microsoft.public.access.tablesdbdesign
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Set Controls Default Value from another Control

...every record they enter on the subform would by default have the PO
number entered.
The data of the subform should be the many side of a one-to-many
relationship and the Master/Child links between the form/subform set on the
primary/foreign key fields with cascade update so that the PO number does not
need to be entered at all.
No need for a table to hold your default information as once it is loaded
into the form fields as default it stays there. What you could do is to
have an event such that after change to set current values as default for
those fields that are expected to be repetive.

--
Build a little, test a little.


"Barry A&P" wrote:

I am working on a form for data entry where the user enters many records that
may have similar information, i am trying to create a tab that would have all
of my "Default" values so that for example if the user was going to enter 40
items from a PO they could go to the Defaults tab and enter the PO# and every
record they enter on the subform would by default have the PO number entered.

I have done this before where my data entry textbox controls default value
is =me![DefaultNotestext] where [DefaultNotesText] is on my Defaults Tab and
it is bound to a 1 record table so the value is there if i close and reopen
the form.

The 1 record table seems excessive can the [DefaultNotesText] be a Unbound
text box that can somehow be set to store the value indefinately

or on activate get the current default value from my NotesText control and
with the afterupdate set a new Default value to my notesText property?

Any help would be greatly appreciated
Thanks
Barry