View Single Post
  #2  
Old February 22nd, 2010, 08:32 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Set Controls Default Value from another Control

Barry,

Stop amd review the design of your tables. You should have something like:
TblPO
POID
PODate
VendorID
other fields pertaining to the whole PO

TblPODetail
PODetailID
POID
POItem (might be ItemID if you have a TblItem)
ItemQuantity
ItemCost

TblPO records data about the PO as a whole. TblPODetail records each item on
a PO, its quantity and its price. Data entry is by a form/subform. The main
form is based om TblPO and the subform is based on TblPODetail. You set the
Linkmaster and LinkChild properties to POID. You don't need to enter POID
for each item in the subform. Access automatically enters POID for each item
in the subform. This ensures each item in TblPODetail is associated with a
specific PO (POID).

Steve



"Barry A&P" wrote in message
...
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