Help With a Search for Data

[gordy2996]

I have a database of information. I have created a form that's function is to scan through a selected column for a matching result and then return all the values on the same row. My intentions are to have the data placed into the matching textbox on the form. If I test this using the exact value it works but when I try having it search the entire column it will not work. Does anyone know how I can make this work. Please help me!

 

[SkipVought]

Access or Excel?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[gordy2996]

Excel

 

[SkipVought]

Do you really need a form? Using AutoFilter can probably do most of what you seem to be wanting to do.

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[gordy2996]

I really do need the form because AutoFilter isn't quite the format i'm looking for, so if you could tell me how to do it using a form that would be great. Thanks.

 

[SkipVought]

If MyVal is the test value then...

ptr = application,match(MyVal,LookupRange,0)
if not iserror(ptr) then
   'got a hit
   for i = 1 to LastCol
      select case i
      case 1
         Textbox1.value = Range("LookupRange")(ptr,i)
      case 2
         Textbox2.value = Range("LookupRange")(ptr,i)
      
      end select
      
   next
end if

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[gordy2996]

That didn't work, I entered the search value and no results were transfered to the textboxes.