Inserting Data in other fields

[Guest]

I am trying to use a macro to insert text from one field in my form to
another field. It keeps giving me an error message. Does anyone know how to
make the macro pull the information from the same form that you are working
in?

 

[Steve Schapel]

Tmac,

Can you please give some more information? What is the error message?
What is an example of the text you are trying to manipulate? Forms
don't have fields, they have controls... are these bound or unbound
controls? What are thge actions you have tried in your macro?

 

[Guest]

They are unbound controls. I am trying to insert a number control into a memo
control on the same form. The error message is the name of another table in
my database and then it says type mismatch. I would appreciate any info you
can give me on this. If you need more information, please let me know.

 

[Steve Schapel]

Tmac,

Well, some more information would have been nice. Like the exact
wording of the error message, and the names of the controls, and some
examples of the data, and in particular the actions you are using in the
macro... these would all help me to understand, and to be able to give a
specific answer.

But if it's a type mismatch, then I would imagine you need to convert
the number to text before inserting it into a memo field, which is
text-based. You could so this by using the Format function, i.e.
Format([YourNumberField])