>I will try your suggestions. Let me clear up something here. the table is a free table. I DON'T have problem to browse the table outside the form. there is a memo field. I deleted the field and recreated but it did not help.
>sherry
Ok, so now we see, it's relevant to the form. Let'see the form code, which gives this error. Check for NULLs just in case (by browsing this table in command window).
If it's not broken, fix it until it is.
My Blog