Just want you guys to check what's wrong with ths SQL Code. I was using VB6 and Microsoft Access as the database. I've used a DataGrid to check if there was a result but nothing appears on the datagrid even though I'm very sure that there should have.I didn't have to explain what the code means I'm sure guys will immediately have knowledge of it.
poproDB.Open "SELECT * FROM payment WHERE pono = ' " & txtPONo & " ' AND cleared = '" & "yes" & "' "
And I'll be definitely be back for more questions cause I'm working on a project. Thanks in advance for your help.