Database search form & results

[Guest]

This is driving me nuts - I have set up a database with a search form (using the wizard). I set the default values but I'm having an issue with one field - the "city" field. Is there some way to use a wildcard? I don't want a specific city to be the default, becuase if a user doesn't specifiy a city, then they would expect records for all cities to show up. As it stands, when no city is specified, the default city's records show up. I hope this makes sense. If you want to take a look, go to

http://dmgdesignsdev.com/gottlieb/ and click on New Home Search. The current default for the City field is "*"

Thanks

 

[Jim Buyens]

-----Original Message-----
This is driving me nuts - I have set up a database with
a search form (using the wizard). I set the default
values but I'm having an issue with one field -
the "city" field. Is there some way to use a wildcard? I
don't want a specific city to be the default, becuase if
a user doesn't specifiy a city, then they would expect
records for all cities to show up. As it stands, when no
city is specified, the default city's records show up. I
hope this makes sense. If you want to take a look, go to
http://dmgdesignsdev.com/gottlieb/ and click on New Home
Search. The current default for the City field is "*"

Specify a default value of % (the percent sign) and a
criteria operator of LIKE.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Guest]

Okay - I got it! I set "Like" in Criteria, and % in Default. It works great! It was a lot simpler than I thought and that was why I was having issues. THanks for your reply. Thanks so much!!!