Searching through Records

[bobby0324]

Ok so have all I have my data fomate and create a form to look at all my data for each record. However, how do i seach through all my records to find to find the one i want? (In execl i just use the find box type in the city, name, etc and scroll through them untill i find the one i want.) I guess basically I'm looking to query using a form. is that possible?

Rob

 

[dkinley]

You can use the built-in filters if you would like - you can search the Help files to get you on this path. It could be complicated if other people are going to use the database.

Another way to 'search' is presented here with a sample database and lengthy explanation. I normally use something along these lines for inexperienced db users.

HTH,
-dK

 

[bobby0324]

Thanks for the reply. The example they show might work. Is there a way to create links in the search results that wourl open up to the full record if i wanted?

 

[dkinley]

I think the detailed explanation uses something like this ... can't recall. If not, this link has an example in the first link on the page that is a great to use. I've used it to open records on the same form and a different form. The modification from one or the other should be clear once you have a gander at it.

-dK