Default Value option

  • Thread starter Thread starter sikelsh
  • Start date Start date
S

sikelsh

Hi all, need some help before i go outa my mind

I got a DB that does purchase orders

The main form has the general fields [supplier, name, job no, dates
total], etc

Then i have a sub form linked to this by job no that you put all th
items in [job no(auto), Description, quantity, cost]

Then i have a sum query to do the math of this subform, so add all th
little subforms up, and it works great, displays the total amoun
fanstastic! in the Sub Form

So back on the main form above i have the field [total] and im tryin
to use the Defauly Value to do the following

=[POtotal_subform].[Form]![Sum Of Amount]

so that the data is entered into the table? not just there on the fly

I know your prob gunna say you should store this, but i really need to


Thanks in advanc

+----------------------------------------------------------------
| Attachment filename: image.gif
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=153313
+----------------------------------------------------------------
 
Sikelsh,

The Default Value property kicks in when a new record is created, so it
is not applicable to this situation. You could put the expression you
gave in your post, as the Control Source of an unbound textbox on the
main form.

--
Steve Schapel, Microsoft Access MVP

Hi all, need some help before i go outa my mind

I got a DB that does purchase orders

The main form has the general fields [supplier, name, job no, dates,
total], etc

Then i have a sub form linked to this by job no that you put all the
items in [job no(auto), Description, quantity, cost]

Then i have a sum query to do the math of this subform, so add all the
little subforms up, and it works great, displays the total amount
fanstastic! in the Sub Form

So back on the main form above i have the field [total] and im trying
to use the Defauly Value to do the following

=[POtotal_subform].[Form]![Sum Of Amount]

so that the data is entered into the table? not just there on the fly

I know your prob gunna say you should store this, but i really need to,


Thanks in advance


+----------------------------------------------------------------+
| Attachment filename: image.gif |
|Download attachment: http://www.MSAccessForum.com.com/forums/attachment.php?postid=153313|
+----------------------------------------------------------------+
Click to expand...
 
Back
Top