i am having trouble with going to the specified record on my form.
I have this form that everyone logs in part numbers and serials which is working fine and now there is a need of a search button so i was browsing internet i found an example that i really like and when i try to implement it to my own dbase it doesnt seem to work and i get this line highlited as an error.
I have checked all fields to make sure they are the right fields but no luck here.
Attached are the samle database (listbox search) and my database called try.
Basically i would like to do what the sample database is doing, except open my own form.
that worked like a charm i guess not only quotes i have to remove the table name and an extra & symbol as well not sure whey though??
One last thing on my form i have setup a macro (onload) when form opens it goes to new record but with search form opens up and filters to a new record and i have to click back to see what i have filtered/searched. But when i remove that macro it works great. Any suggestion on how can i have my form goes to a new record and still be able to search it like that??