combo not in list

  • Thread starter Thread starter lez
  • Start date Start date
L

lez

Hi Guys,

I have been using some code behind my 'not in list' for a combo box in my
Access 2007 database. It worked fine when linked to ACCESS BE, however, I
have now moved to an SQL BE and the code does not work and keep getting the
following error message:

Run-Time error 3622

you must us the dbSeeChanges option with OpenRecordset when
accessing a SQL Server table that has IDENTITY column.

Can anyone advise on this or where I might more information on handling
this?

Thanks
Lez
 
Back
Top