View Single Post
  #1  
Old February 22nd, 2010, 07:30 PM posted to microsoft.public.access.tablesdbdesign
Barry A&P[_2_]
external usenet poster
 
Posts: 119
Default Set Controls Default Value from another Control

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