ADP form refresh problem...

[Michael Palmer]

I have access 2000 connecting to SQL server 2000. When I
create a new record the Identity field for this new record
does not populate until the record is saved, by a
form.refresh or what-have-you. BUT... when I do a
me.refresh or me.requery the record clears from the form.
It is indeed saved in the table but it disappears from the
form. I could work around this but certain areas of the
form's code depend on the records ID key, but this problem
continues rearing its head. I've developed dozens of
Access MDB database, but this is my first commercial ADP
using SQL server. Any ideas? Thanx

 

[Van T. Dinh]

(Guessing as I don't use ADP)

Try using

Me.Dirty = False

to save the Record and should get the value of the Identity Field after
saving.