I seem to be having a lot of trouble with unbound text boxes. I have about 40 that I’m doing a lot of calculations in them. Some of them have numbers that are from other tables but don’t need to be saved with the new record. If I bound them the problem goes away. Is there anyway to create another table and bound the unbound boxes there and empty it every now then. If not do you have any suggestions besides stop fooling with Access

Thank you for your help

I'm not clear what the problem is. Are they staying populated when you move to a new form, and therefore screwing up your next calculations?
You might try Me.Unboundbox = "" in Form_Current.

HTH,
David R

P.S. Hayley Baxter just reminded me that you could possibly use the Requery action to clear all your unbound fields at once. Use at your own peril. http://www.access-programmers.co.uk/ubb/smile.gif

[This message has been edited by David R (edited 01-10-2002).]