0

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.

5
Contributors
6
Replies
8
Views
9 Years
Discussion Span
Last Post by electrosoul456
0

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

0

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

0

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

0

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.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.