The form inputs the actual value for B and BR, eg., but if they leave it
blank, I put in the wildcard with the = or assignment operator and it will
call up all the types.  Seems to work!

I found my error though in the B and BR... It was in the database, not in
the query. The catalog's old designation for both bracelets and brooches was
B. I uploaded the data but failed to change the TYPE designation for those
items ! :-) 



On 9/26/02 4:28 PM, "John Pirkey" <mailjohnny101@y...> wrote:

> 
> but the wildcard only works, i think, when you use the LIKE operator.  so, if
> you
> changed the = to LIKE, it should work.  but then, when they want something
> specific,
> if there's anything else LIKE that (B and BR, for example) both will be
> returned.
> 
> john

~~~~~~~~~~~~
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.net
Tel .  xxx-xxx-xxxx
ICQ 19112253

http://www.Slippery-Rock.com - 7,000 hits per year