Hello, I got this code below i don't know what actually is wrong with it as it keep
giving me error (No Value Given). Seen like it could not extract the value (which is in Text format) from the text box.

Adodc2.RecordSource = "select ven.*, claim.*
from claim, ven where ven.field1 = claim.vendor and claim.hpcode = " & Text67.Text & ""
Adodc2.Refresh

Thks & regards.