SQL in VB

[scitech]

I have two joined tables
I use a macro to open a form (+ subform) with a filter query
the dialog for user input from the first table works fine
when I try to add another criteria from the second table to the query another dialog box opens (unexspected)and the query breaks down.
The query works fine on it's own
What is going on, and yes I should use VB but I don't know it.I have tryed pasting the SQL into VB, following some directions, but keep on getting syntax error messages!
charlie

 

[psemianonymous]

You posted the same question a while ago. The answer is that this isn't possible without using some flavor of VBA, somewhere. You're trying as hard as possible not to use VBA but you have no other option here.

 

[scitech]

Thanks I knew I would It just that I cannot get it to work

 

[Ed2020]

Scitech,

Post the SQL and table design details and we may be able to offer more assistance.

Ed Metcalfe.

Please do not feed the trolls.....