problem with parameter query

  • Thread starter Thread starter Dogface
  • Start date Start date
D

Dogface

I'm having problems with a parameter query I created. The user specifies a
"ProductID", which then displays not only the "ProductID" but also
"OrderID", "CustomerID", "CompanyName", "ProductDescription", and
"Quantity".

I test this by just running the query, which then prompts me to enter a
valid "Product ID Number", if I enter an invalid number it doesn't bring up
the validation text. It just brings up a screen with no data (since its an
invalid ProductID). If you put in a valid ID, then the appropriate data
comes up.


I have the following field properties set for "ProductID"

Field Size: 3
Input Mask: 999
Validation Rule: Like "###"
Validation Text: You must enter a three digit Product ID.
Required: No
Allow Zero Length: No
Indexed: Yes (No Duplicates)

Any ideas why? Is there something wrong with the validation rule?

I'm completely stumped.

Thanks
 
Back
Top