I'm having a problem with adOpenKeyset not returning the primary key value for a row after data is entered. I have the same code working on many other tables & pages, but for some reason, it's not working here.
There is a trigger for insert on this table that creates a new entry in another table, and I'm thinking that may be the problem is.
Here's the code - FYI, stripIt(n) is a function to trap any malicious input, and companyID is the primary key on this table.
rs.Open "tblCompany", conn, adOpenKeyset, adLockOptimistic, adCmdTable
for each fld in rs.Fields
IF fld.Name<>"companyID" AND len(request.form(fld.Name))>0 THEN fld.Value=stripIt(request.form(fld.Name))
I can't seem to find any info on this anywhere, so any help is greatly appreciated.