G
GD
I have a form that has text boxes that calculate the breakdown of unearned
discounts from one of our checks to a vendor, based on dates, terms, etc.
Ex: =DSum("[DiscAmt]","017_PastDuePerEntryDate_q","[AddRPYCK]='" &
[txtFergusonChargebackNo] & "' AND [DCNo]='" & 39 & "'")
What I need is:
1) to bind these expression results back to a table (I know I use Control
Source to bind it, but what property would I use for the expression?), and
2) give the user a manual override option within the same text box (i.e. the
override would then take the place of the expression result in the table).
Can these be done?
discounts from one of our checks to a vendor, based on dates, terms, etc.
Ex: =DSum("[DiscAmt]","017_PastDuePerEntryDate_q","[AddRPYCK]='" &
[txtFergusonChargebackNo] & "' AND [DCNo]='" & 39 & "'")
What I need is:
1) to bind these expression results back to a table (I know I use Control
Source to bind it, but what property would I use for the expression?), and
2) give the user a manual override option within the same text box (i.e. the
override would then take the place of the expression result in the table).
Can these be done?