coding for finding a certain field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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??
 
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?

....
 
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.
 
Back
Top