.Execute query with form criteria

[brother]

Hi!

I'm writing an append query in SQL/VBA and I want to be able to trap errors when running the query. Using .Execute is a good way to do this, the only thing is that is does not work when refrencing to a form field as a criteria.

Ex. [Forms]![frmExample].form![txtExample]

Is there a way to work around this?

A pointer in the right direction would be superb!!


Thanks!

 

[namliam]

You have to substitute variables in
.execute "Select columns from table where id = " & YourVariable

 

[ions]

CurrentDb.execute strMyQuery, dbFailOnError doesn't work if you have the following in the strMyQuery Criteria / Parameter and the form is open?

[Forms]![frmExample].form![txtExample]

It should I think. Make sure your form is open.

 

[LPurvis]

It's the day for this kind of thing - isn't it?
http://www.access-programmers.co.uk/forums/showthread.php?t=183066

 

[brother]

Thanks for your responses. I'll take a closer look at your link LPurvis and see what I can make of it