How to search an access database

meetmaruthi's Avatar
Newbie Member
i have 13 fields in my access table.it stores the admission information of a table.now if i click open on particular form it shows a dialog box .it contains a textbox in which i type the admission number of student. i need the particular record associated with it and i want all records to be retrieved into respective texboxes.

I am using data1 control on form to connect to ms access and vb 6.0
pls help me
coderzone's Avatar, Join Date: Jul 2004
Team Leader
Either you need to be firing the SQL or you need to be matching them by moving through each id in the data control.
rahulnaskar's Avatar, Join Date: Aug 2004
Go4Expert Member
possibly, the easiest one is to change the sql of your data control and make it like:

"select * from <table> where <field1> = <value>"

where table is your table name, field1 is the field you want to search and value is the value supplied by user, and refresh the data control. You will be having the desired record in shortest possible time and can refresh the form with retrieved fields.

Hope this helps...

Rahul