Robert,

<< There is a way to get this effect (I think) but it is rather bizarre. If
you have a filter on the table that filters out any autoincs > 0. The moment
you post, your record is gone. The null field as integer returns zero. >>

Yes, that would be one case where you have a fly-away record.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote in message
news:15D085B8-A184-4A74-AC79-E37AA712D9E3@news.elevatesoft.com...
>
> "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
> news:80552AA9-FF34-406C-89F7-11606F0DDA9D@news.elevatesoft.com...
>>
>> << I have been using the Append method.  Is there a difference in the
>> availabilty of the autoinc value? >>
>>
>> Nope, no difference at all.  They both should work fine.
>>
>> I'm with Robert on this one - you're going to have to trace through
>> things
>
> There is a way to get this effect (I think) but it is rather bizarre. If
> you have a filter on the table that filters out any autoincs > 0. The
> moment you post, your record is gone. The null field as integer returns
> zero.
>
> Robert

You're good!  This table had been previously used for another function in
the program and had a leftover filter applied:  "QuoteNum = -1", so that
data wouldn't be displayed in its associated bound controls until a new
filter was applied (which never happened in its new incarnation).  Thanks,
that was some great insight (and a silly oversight on my part)!