This may be a stupid question, but is there anyway to add a new field to a form?

I created a new query with some totals in it but it seems if i cut and paste one of the fields i currently have and change its controll source, but all I can do is reference it. That doenst' work though because it says that the query isnt loaded yet. I've tried SetValue etc. but the only way I can seem to get this on to my form is to redo the form and add it with the wizard at the beginning.

Open the form in design view and delete the name of the query from the recordsource. Save the form, and then re-add the query name. You may need to force the form to refresh its field collection.