>Eric,
>yes, we have lots of fields. But for the purpose of testing whe just included one on the form.
>
>Here is the Microsoft Visual Basic dialog box error message:
>
>Run-time error -2147467259(80004005)
>Insuficient result space to convert uniqueidentifier value to char.
If fields don't have default values and don't accept Null, you are in trouble. Do a test with a small table that only includes 1 or 2 fields.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com