Bound expression or manual entry override option

[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?

 

[Jeanette Cunningham]

Hi GD,
there is a sample database that shows how to do this sort of thing.
http://allenbrowne.com/TechniqueEnterCalcText.html


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia