Query Help

[ScrinnBatt]

Good day all

I have two questions which I would like help with please?
My database is a Machinery Faults database, and has a form that a user can
enter all details for the fault and how it was repaired.. I have made a
number of queries based on machinery Serial Numbers, Part Numbers etc. I
have a field (a checkbox) in the form that relates to whether Outside
Technical assistance was required.

1. How do I set up a Query to run so that it pulls out only those forms with
the checkbox ticked? I tried Is Null and Is Not Null in the TechAssist field
but they return all records.

2. With the majority of the quieries I have set up successfully, I get a pop
up box for the user to enter data, i.e if he wants to obtain all the fault
cards for a certain serial number, he will enter the serial number in the
box. However I would like to make the text above the box more user friendly
so instaed of

[Forms]![fmFaults]![SerNo]

I would like

"Please Enter Serial Number"

Many thanks in Advance

Matty

 

[MGFoster]

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

1. For Yes/No columns (Fields) you use True or False, you don't check
for NULLs.

WHERE TechAssist = True

2. The query's prompt can only be a reference to a form
(Forms!fmFaults!Ser), or, a user Prompt (Please Enter Serial Number).
Since your query is looking at the form "fmFaults," just make sure that
form is open when the query is run and the control "SerNo" has valid
data. When that form isn't open the form reference prompt appears.

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

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

iQA/AwUBQgz+m4echKqOuFEgEQLVfgCaAv9DmnX9hQLliBSF6vqFh6mlC68AnR8s
TUfuL8FChKvSP50uXCkSLPrY
=RWZr
-----END PGP SIGNATURE-----