Upsized to SQL Server BE - Requery causes Access to crash

M

Mark

I have recently upsized an app to a sql server backend. After a few
alterations it is working well, apart from when I am requerying forms. When
I use Me.Requery or Me.subform.Requery, access crashes with the "Microsoft
Office Access has encountered a problem and needs to close" error message.
I have since discovered that my problem was omitting the "form" from my
requery so Me.Requery becomes Me.Form.Requery and Me.Subform.Form.Requery.
Can anyone explain the difference & why Me.Requery works with a jet backend
but not a sql server be?

Thanks
 

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

Subform Requery Criteria 1
SQL Server Backend is Read Only 7
Trouble upsizing Access to SQL 5
Opinions on SQL Server upsize 13
MS SQL Express 2008 10
Access parameterised queries upsizing to sql server 2
Access to SQL Server 9
Upsizing wizard and SQL Server 2008 Express 4

Top