tirso 0 Newbie Poster

hi to all, pleas bear with me co'z I am a newbie with this environment. I have a microsoft access database and I already have tableadapter. I have already a forms that the operator input the name with the text box then searh with my database. After it successfully searched then fetch another information like bill, amount and display it with my forms. Is tableadapter advisable to use for search and fetching records and display with my forms or better to use sql.
Please give me any idea and sample

Thanks in advance

Tirso