Hello Sir
I want to retreive a result by entring a key value in a
textbox and when i click button the reseult should beshown
on the bases of that key value which i have entered in the
text box.
For example:
I want to retreive the Author's name by entring the author_id
in a textbox.i want the author name should display in an
other textbox.
Is it posiable.
I hope u will help me.
Thanks

arshad mahmood

__________________
arshad mahmood

I use the recordset method so you can put something like this in your Click event....

Dim cxn As ADODB.Connection
Dim rst As ADODB.Recordset
Dim strSQL As String

Set cxn = New ADODB.Connection
Set rst = New ADODB.Recordset

'I use an Access DB if you use something else - like SQL -
'your connection will be a bit different
With cxn
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
"add the absolute path to your data here"
.Open
End With

strSQL = _
"SELECT MyTable.strAuthorName" & _
"FROM MyTable " & _
"WHERE MyTable.intAuthorID= " & MyForm.TextBoxi & ";"

rst.Open strSQL, cxn, adOpenStatic, adLockReadOnly, adCmdText
    
txtResult.Text = rst!strAuthorName

rst.Close
Set rst = Nothing
cxn.Close
Set cxn = Nothing

Hope this helps you out.....

Kenny Alligood