how about this :
Place all the textboxes for displaying the fields of the table.
Have a separate textbox to enter the account number say txtaccno
Then :
adodc1.recordsource = "SELECT * FROM accountholder WHERE accno = " & trim$(txtaccno.text)

This will let you see all the fields of the record