>Thanks, Jim. Your explanation of what's happening is, as always, lucid.
>
>Now, my question is: would it be better to INSERT INTO the values I'm going to need, and not depend on the default field value? If so (this is how I've done it in the past), then can I safely leave the field-level default values? IOW, since I've INSERTed INTO an ID, will the default value NOT fire since the field's not blank? I think your message implies that, but I'd just want to check.
>
>Thanks, again.
>
>
>...snip
>> Requery("TheView")
Nancy,
You are correct if you supply a value for the ID then the default will not be used. BTW, you can give your view field the same default expression adn then appending a record to the view will put the id in there for you the saem wya it is now for the table.