Newbie - Search Form

[tweetysamm]

Everyone,

Im new in Microsoft Access, please give me some advice on this :

1. Im currently using Access 2002
2. I got a table with field (AccNo,IC)
3. I need to build up a form to search for the IC whenever i input the AccNo

the problem is i don't know how to do it ? I find all the reference but can't get much ideas on this

thanks for advice

 

[ColinEssex]

The easiest way is to put a ComboBox in the form header. Use the wizard and one option offered will be "find record based on selection" etc

Col

 

[tweetysamm]

Problem is ~~

But my problem is to search "Account Number" which consists of few hundreds thousand of entries therefore is not feasible to use combo box to perform the search function..

1. i need a text box to capture the input search detail
2. perform the search in the database
3. display all the particulars for the account in a well display manner

but im still stuck in capturing the string from the text box

 

[office_guru]

Try a parameter query

Create a form with an unbound text box which will be your account number input, name the form.
Create a query using the table that has the information you want to show in the result including the field your searching on. In the criteria of the field you're searching on write: [forms]![form name]![field name] (reference the form and field you created).
Go back to your form and use a botton to run a query which is linked to the query you just created.
When you input your account number and run the query the query should pop up with the information in your query. If you want the result to be prettier than a query result, not sure what to tell you.

Good luck!