setting a filter creates a new record. why??

[bkatz]

hello,

for some reason when i set a filter in code it's creating a new record. any idea why?????

Me.Filter = "PK_ID = " & lPKId
Me.FilterOn = True

The filter works, but a new record is always created, which i do not want. i'm stumped!

 

[scking]

Is there data in the new record or is it merely the AddNew record? Are the AllowAdditions or DataEntry properties set to true?
-------------------------------------
scking@arinc.com
Try to resolve problems independently
Then seek help among peers or experts
But TEST recommended solutions
-------------------------------------

 

[Junior1544]

maybe your setting the filter to show a record that doesn't excist, I've seen filters do that befor...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.