Hi Mark ---
Yes. You have to with VALUES or FROM ARRAY or FROM MEMVAR. But I haven't found this to be a problem....very rarely do I want to totally default ot blank and even if I do I can just add a clause like INSERT INTO table name VALUES SPACE(30) or something like that.
>>For two, APPEND BLANK may generate errors if a primary or candidate key has been defined and blanks are no-no's.
>That's not the case when the table is buffered though, is it?
>
>With INSERT INTO, don't you have to populate it from memvars, instead of just APPENDing BLANK and letting the user fill in bound controls?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05