Search field on Form

[klynch0803]

Good Afternoon everyone...

I have attached a basic form so maybe someone can help me out and I can get the concept and build upon it in my actual database.

In the form fdatMemberLookup I want to be abel to enter the MemberID and click Search. It will then search a table and show the records on the form.

Now I do not want to insert actual Table fields on the form so it isnt physically linked as a control Source so I assume I need to do maybe some kind of strsql or something maybe even simpler than that to find an d show the data.

Would somone possibly show me how to do this in this simple database so I can try it in a much larger?

 

[chris davies]

Take a look at this link, it helped me immensely. All I had to do was replace the variable names for it to work for me. My form only had two fields which were based on a query, I added an extra text files and command button, pasted the code and it woked like a charm.

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

 

[klynch0803]

Take a look at this link, it helped me immensely. All I had to do was replace the variable names for it to work for me. My form only had two fields which were based on a query, I added an extra text files and command button, pasted the code and it woked like a charm.

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

I actually have that code and it works great you are right. You sparked what I needed to do thank You. I needed to build a query and reference that instead of the table ty for the push I was stuck.. The most simple answer is always the one we don't look for..