[RESOLVED] Query builder challenge within VB.NET

[victorpc553]

Hey gurus, I'm working with VB 2008 and access 2007.

I want to use the query builder(QB) to create a search of the database using a specific parameter (textbox) that this QB is supposed to also create automatically at the end of the process.

One picture speaks more than 1000 words so you can see below the problem that I'm getting while trying to finish the query. What I am doing wrong?

[jggtz]

AFAIK, parameters in Access are sorrounded by []

http://www.fontstuff.com/access/acctut01.htm

[victorpc553]

Thanks,

however [] will create the prompt and is not the objective.

Instead I need the query builder to read a value from a text box. Anyone has accomplish this?

[si_the_geek]

jggtz is correct for parameters within Access, but to pass values from your program the parameter placeholders should be just ? (with no name afterwards), eg:

WHERE (MFNAME LIKE ? + '%')

[victorpc553]

si_the_geek ..just tried your answer and it worked super...

I'd spent hours reading without find it..so I trully appreciatte it. Thanks.