Bound control but updated via calculation?

[SimonPGreen]

Hi,

I have a requirement to have a control on a form that meets the following criteria:

1. Is bound to a table field
2. Has its value automatically calculated based on the value in a related table (Could use dlookup)
3. Can have a manual value overwrite the calculated value

Example:

Net Value = £1000
Discount = £100 (calulation based on discount percentage stored on supplier details)
New discount = £150 (as negotiated on a one off basis)overtyped over the £100 value

I appreciate that I shouldn't store calculated values in the table but have compelling reason to do so in this instance.

Not sure how I bind, display and write different data?

Hope this makes sense

Appreciate any help.

Simon

 

[Pampers]

Maybe you can put the calculation for the bound control in an after_update_event or on a button_click.

Me.BoundControl = Me.Control1 * DlookUp("","")

or something like that

Pampers
Keeping it simple can be complicated

 

[Remou]

You can use code to update a bound textbox with the default value, or set a default value for the textbox:

[tt]=DLookUp("Field1","Table1")[/tt]

Setting a default value will only work for new records.