Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search Form

Status
Not open for further replies.
bf2mad

bf2mad

Programmer
Nov 26, 2002
33
GB
Hi,

I am using MS Access 2000.

I am having some problems trying to create a search form. The form has arround 10 text boxes (Reference number, first name, surname, full name, Account, category, status,date added, date resolved.

I have tried creating a query where the criteria is set to something like [forms]![frmSearch]![Account] however when the query is run no records are displayed. Is there any way that if the text box is empty then all of the records for that field is returned.

Ideallily would like this to be in the form of a query.

Ideally the user will be able to search by multiple fields such as first name and date added and all of the records that macth these fields will be displayed in a list box

Any ideas

Thanks in advance
 
Status
Not open for further replies.

Similar threads

duytoi
  • Locked
  • Question
How to add a head to the search results in Excel 2016 using VBA
Replies
2
Views
2K
Andrzejek
Andrzejek
Andrzejek
  • Locked
  • Question
Formula with & and a single quote 2
Replies
4
Views
989
OzFoxy
OzFoxy
PSchubert
  • Locked
  • Question
Excel: Formula only works with certain numerical values
Replies
12
Views
1K
dhookom
dhookom
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
987
bs6600
bs6600
TrekBiker
  • Locked
  • Question
I'm very near a solution for form 1
Replies
3
Views
257
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top