Searching a Table (1 Viewer)

RadioProject

New member
Local time
Today, 08:33
Joined
Dec 16, 1999
Messages
5
Is it possible to create a form that has say three fields in which you can enter either an ID, Name or something else and then use these values as the imput to a search into a particular table?
 

Clarence

Registered User.
Local time
Today, 08:33
Joined
Oct 3, 1999
Messages
14
Yes this is a very useful technique to learn as it has a great deal of flexibilty.
The pricipal behind it is taht you can reference values on forms from query criteria.
Example
Form name frmMyForm1
Form contains 2 fields
txtBEGINdate
txtEndDate
the query contains 2 fields you want to select on [MyAccountStart] and [MyAccountEnd}

in the query criteria for [MyAccountStart]
use

>= [forms]![frmMyForm1]![txtBeginDate]

in the query criteria for [MyAccountEnd]
use
<= [forms]![frmMyForm1]![txtEndDate]

You can amend this example to meet your needs. the great flexibilty of this method is that you can use values from multiple forms if you want to.
Hope this helps
 

Users who are viewing this thread

Top Bottom