Thanks! That worked! I appreciate your help!
Amanda
>There really isn't a type "Memo" for variables. Just make it a character. I would reccomend storing space(999) to it, or use what ever length you expect for the 999.
>
>>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