searchs

[dreamdelerium]

hey guys, im sure this question is somewhere in the forum but im currently serving in the peace corps in africa and it cost a lot to get on the internet here. heres my question. i have a form that i want to search a table to find a value that the user inputs and returns what it finds in the form of a string. i can do the form part i just dont know how to search my table and return a string. thanks

 

[MarkK]

You want to search all fields? You want to return a string from any field, a particular field, or do you want to find a particular record?

 

[ajetrumpet]

From what it sounds like, you are going to be searching for values in field cells that contain multiple strings, and you want to join those strings into one long string when the values are returned....does this sound right??

There might be an easier way to go about the process, depending on what exactly you are trying to accomplish in the end. Do you have any more information??

 

[mattyj1990]

Look at

http://databasedev.co.uk/text_search.html

It explains how to search for data using a text box on a form

 

[ajetrumpet]

nice referral Matty. Good Info!

 

[dreamdelerium]

thanks

thanks for the link. heres what im trying to do: i have a form that will enter data into a table. before it can enter the data, it needs to search another different table for a value. once that value is found it will concat it with the value the user entered into the original form. i downloaded that link and will read it when i get back to my house. it looks like i might be able to use it. thanks again