certain values in query criteria

[Only1Abhi]

Hi
Can any1 help me plz!

I have a table called Pots
I have a query called qryPots with all fields chosen:

Pot ID
Pot Size
Pot Design
Pot Description
Pot Price

I have parameter queries on all fields EXCEPT POT ID with text [Please type the pot size/design/description/price]

I only want certain values to be entered into these parameter query windows.

e.g. For the pot size,

Only values SMALL, MEDIUM and LARGE should be allowed to be entered.


Does any1 have a solution?

Many thanks in advance.

regards,
Mark (abhi's friend)

 

[Robert Dunstan]

Hi there

Why not create a form that asks for the criteria. Then in your query you pass the values to the criteria by using the following syntax

[Forms]![frmMyForm]![cboPotSize]
[Forms]![frmMyForm]![cboPotDesign]
etc..

This way you can design your form to whatever you want and can have an unbound combo box for pot size and set it's rowsource to a value list etc. etc.

Just a suggestion

HTH
Rob