Thanks for the quick reply! I'm not using the scatter command, but it's definitely worth a try. When I declare the variables, I declared them Public and it changed all the data types to logical. I need to change the memo field back to memo.

Thanks again!
Amanda

>If you are creating the memvar's with a scatter command, don't forget the memo keyword.
>
>Other than that, if there is a variable with the same name as the memo field, insert into mytable memvar should try to stuff the value of the variable into the record.
>
>HTH
>
>>I have a blank form that users enter new provider info into, this form does not have a controlsource. I'm declaring variables and using insert from memvar to insert into my table. My problem is, I have a memo field for users to type notes but the memo field refuses to go into the table. I had to initialize some of the other variables (ie. date, char, etc), so how would I initialize a memo variable?
>>
>>Thanks in advance for any help!!
>>
>>Amanda Brown