Re: new query

Thanks, but "Cannot execute a select query." :-(
I do not wont to make a few new tables.
In my db is a form, where are a few checkboxes and listboxes. The user
will choose his choice. That is all. I need only create new query by
users choice.
Sorry, my bad english :-)

Paja


[EMAIL PROTECTED] (John) wrote in message news:<[EMAIL PROTECTED]>...
> I'm going to assume that you are asking for vba code to build and
> execute a query in an access code module. If that's not what you need
> then please rephrase your question.
> 
> strSQL = "Select * FROM tblMyTable WHERE UserID = jobrienct;"
> CurrentDb.Execute strSQL
> 
> regards,
> 
> John
> jobrien AT acscience DOT com
> 
> [EMAIL PROTECTED] (Paja) wrote in message news:<[EMAIL PROTECTED]>...
> > Hi,
> > 
> > I need to make a NEW query with help VB code in Access. In the VB is
> > not something like createquery, addquery or newquery. Thanks for your
> > answers.
> > 
> > Paja