Urgent: Echo Method

[StefanScheidegger]

Dear colleagues

Can you help on this?

I have a form where users may enter data. Right after the input, MS Access should update a field in a query without actually showing the query table.

So far I tried the following with the help of a Macro.

Echo False
Openquery

Unfortunately, MS Access opens the query although I put "Echo" to false. Does anyone know what I am doing wrong? Is there a solution with an easy VBA code?

Stefan

 

[FancyPrairie]

I'm not sure what you're trying to do with the query. But here's some code that will execute the query via code.

Dim cnn as ADODB.Connection

Set cnn = CurrentProject.Connection
cnn.Execute "Your SQL String"

 

[shannonp]

Try

Docmd.SetWarnings False
Openquery
Docmd.SetWarnings True

 

[Magellan]

Just an addon note to shannon...

Docmd.SetWarnings False
Docmd.RunSQL 'string containing sql statement'
Docmd.SetWarnings True

Cheers!

In the sweat of thy brow shall you eat your bread