appending calculated fields

[Guest]

This is driving me nuts.
I have a form that calculates total sales and commissions for sales reps.
You select an employee in a list box and the two calculated fields are
updated. This works fine. Now I want to append one record to a table with the
information and some other fields that the query picks up from the source
table for the form. In the query the two calculated fields show up as
gibberish ( rectangles and what looks like oriental characters). The
appended record contains blanks in the two fields (or null?). I tried to
change the format of the fields (numbers, currency) but no help. Any
suggestions?

Thanks

 

[Guest]

Sounds like you need to refresh the form to update the underling data.

after update event should have me.requery

Regards,

Stewart Rogers