combo not in list

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 and SQL Server 2005 and DAO recordset 1
Code won't work 1
combo list on request 2
3622: You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that 5
You must use the dbSeeChanges option with OpenRecordSet whenaccessing a SQL Server table that has an 1
must use dbSeeChanges option with Recordset 5
dbseechanges error 3622 2
dbSeeChanges are already there 6

Top