change search criteria in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H

I am completeing a relational database for some AVCE coursework (UK).
have created a query which i would like to use as a template and it i
necessary to alter the search criteria in one field. Is it possible t
create a form or something more user friendly to change this or must it b
done in design view. The idea of the scenario is to create a database for
novice to use

thank

Gar
 
geepeetee said:
Hi
I am completeing a relational database for some AVCE coursework (UK). I
have created a query which i would like to use as a template and it is
necessary to alter the search criteria in one field. Is it possible to
create a form or something more user friendly to change this or must it be
done in design view. The idea of the scenario is to create a database for a
novice to use.
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

A criteria value can be accessed by reference. E.g. (SQL View):

PARAMETERS Forms!FormName!ControlName Long;
SELECT *
FROM TableName
WHERE ColumnName = Forms!FormName!ControlName

When the form "FormName" is open & the query run, the criteria will be
retrieved from the ControlName on the form.


MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQE+J64echKqOuFEgEQKK3ACgg4omHsM98fCVnXHvphGnqa72uCQAn3s4
jdnVT/MOjLgAee53Boj6Qi1i
=auqT
-----END PGP SIGNATURE-----
 
Back
Top