Dear friends pl help me
I want to select data from a data base table Tran with two selection criteria one is number and the other one is
text When i use one criteria it works well But i am failed to use the two criteria
my code is here for one criteria
`TRS.Open "SELECT * FROM Tran WHERE Acno =" & Val(TxtAsnno.Text), CN, adOpenStatic, adLockOptimistic
I want to use Acno=val(txtAcno.text) and Name= txtName.text
Please help me