How I find out data from access
 

I use data control to link access file by data properties not code. use simple code like move next etc. I use find next to find data. but when i want to find i write the criteria like Name = taher. But i want I write only taher in find text box.

Re: How I find out data from access
 

so what is your problem ?

Re: How I find out data from access
 

I only write, what i want to find. not critera. but now i write "Fieldname = condition" but i want only condition

Re: How I find out data from access
 

You mean you want to find data where Fieldname = condition ?
And condition is user input?

Re: How I find out data from access
 

yes only condition is input. now i write like Name (fieldname) = taher (condition) but i only input taher (condition)

Re: How I find out data from access
 

Hi, First get the input from the user Say (sName) and use Field Names in your coding not as input.

Example

 Recordset.Find  "Name'=" & sName & "'"

Here you only give the condition (sName or txtName.Text that is Input) and Field name is predefined by your coding.

Re: How I find out data from access
 

use variable to get text value in it and then apply your code on that variable