query parameter?

J

js

Hi, how to create a query can accept parameters, and how to avoid
that(sometime I see a popup box for asking parameters for this query: select
* from tb1 where id not in (select id from tb2)? Thanks...
 
M

[MVP] S.Clark

The popup that you see is a prompt for the parameter, so this is the UI for
it. It's not great, but it's the quick and dirty method. If you need
something better, you can build a form, then have the query look at the form
for the values.

Select * from tablename where somefield = forms!formname!controlname
 
Top