Select In problem

[prometro]

Hi, I have problem with propably easy thing.

- in example on picture in appendix named "foto1" I can find records with ID 1 or 2 or 3. It works.

- but on picture "foto2" where instead of values 1;2;3 is textBox in form with the same data, it doesn't work. I dont know why ...?

I know, that I can do it in VB code, but for this application is much easier to use query table.

Please, If you know answer, help me, thanks!
Jiri

 

[vbaInet]

Your textbox is returning a string block whilst the parameter in your query is expecting a list of integer values.

 

[namliam]

Your foto 2 doesnt end up being the same as foto 1
Instead of in (1,2,3) you have in ("1,2,3"), i.e. the 1,2,3 is one value insteda of 3. unfortuatly it dont work that way.

 

[prometro]

Thanks for reply! So, is there some other possibility to do it? What I can change to do functional query ? Jiri

 

[vbaInet]

You would have to build the SQL string and execute it using VBA:

http://baldyweb.com/BuildSQL.htm

 

[prometro]

thank you, I started work on in.
Jiri

 

[vbaInet]

Goodie! Post back if you require further help.