Database Search

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using FP 2002 to make a results page of an access database. I want to have two search field on the page so users could search by either field or by both. When I test it the first field does not search without something in the second field. What am I doing wrong?

Thanks
 
Hi,

When you click on "Add Criteria" button, the last option there is
"AND"/"OR", you can select "OR" here to make it optional (one of the two).
Ensure you have default values for both.

Regards,
Vijay

Disclaimer: This posting is provided "as is" with no warranties and confers
no rights

--------------------
| Thread-Topic: Database Search
| thread-index: AcQHskS890RH2m+sQaSaeLIN9SbTxQ==
| X-Tomcat-NG: microsoft.public.frontpage.client
| From: =?Utf-8?B?TmF0aGFuaWVs?= <[email protected]>
| Subject: Database Search
| Date: Thu, 11 Mar 2004 13:46:11 -0800

| I am using FP 2002 to make a results page of an access database. I want
to have two search field on the page so users could search by either field
or by both. When I test it the first field does not search without
something in the second field. What am I doing wrong?

Thanks
|
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

database search 1
Access Microsoft access database(creating a search engine form) 0
Database Search. 1 Search box, to search multiple db fields 4
Database Results Error - FrontPage 2000 3
Help with Database Search 2
Search Function 1
Database Editor Problems 7
MS Access problem 0

Back
Top