coding for finding a certain field

[Guest]

The company i work for builds racks for the automotive industry. each rack
"job" is individually numbered. In one of my forms there is a "job search"
field, so when i put in a specific number it automatically go to that job. I
had help in making this work. This is my problem, within that same form i
need to do a "rack code search". i tried to copy the coding from the job
search with changing the information for the rack code search and it wouldn't
work...any suggestions??

 

[Guest]

There are many possibilities why it's not working.

Does it give errors? what is not working?
Have you tried to debug? Is Job search a number and rack code not a number?

....

 

[Guest]

It does give a Run-time error '13' Type Mismatch and when i try to debug this
is what is highlighted:
rs.FindFirst"[Rack_Code] =" & Str (Me!{RackCodeSearch])
Everything is showing up like it should, it just doesn't pull the record
with the particular rack code that i input. Both fields are text fields.