Im trying to create a search function on a form that will allow me to type in a Surname (from PersonalDetails table) and return all fields corresponding to this person and everyone else with this Surname, in a view that can be edited. The in-built search function only shows one record at a time.....and u have to scroll through them.
BELIEVE ME ive tried the Help Files, writing SQL statements, VB Code, various text books and still can't get my desired result!!!!
U guys are my only hope ....please help if u can!!!
Ok... Well what do you have so far? It sounds to me like you need a form for your search criteria and the "result view" ... That form would be a continuous forms form and it can be based on a single table which would allow for your direct edit ...