DBGrid

[lomano]

I am doing an assignment in school that requires me to use DAO with and Acces Database. What i want to do is to display my search results into the DBGrid.

I have set up a temporary recordset and have used SQL to retrieve the data i am looking for.

SQL = "SELECT * FROM PersonalContacts WHERE" _
& " Name Like '" & result & "*'"
Set fSearchresultRS = fcontactsDB.OpenRecordset(SQL)

How would i go about taking the results of this and putting it on a DBGrid.

Thanks

 

[edderic]

Take a data control (data1) and bind it to the DBGrid (Poperties DataSource )

SQL = "SELECT * FROM PersonalContacts WHERE" _
& " Name Like '" & result & "*'"
Set fSearchresultRS = fcontactsDB.OpenRecordset(SQL)
Set Data1.Recordset = fSearchresultRS

Succes Eric De Decker
vbg.be@vbgroup.nl

Licence And Copy Protection AxtiveX.

Download Demo version on my Site:
Promotions before 02/28/2001 (free source codebook),visite my site

http://www.createsoftware2000.com

 

[lomano]

Thanks. that worked perfectly...