Search results

I have an SQL statement with a WHEWRE clause within my VBA code. The idea is the user can search for data from a search form. If the search only returns 1 record how can I open a form based on that returned record. ie if the search returns an employee ID on '10', is it possible to open the...

I have a search form which searches a table for employee records. To keep it simply I am trying to get it to work only on the surname textbox at the moment. To do this I have a global string that has the 'WHERE' part of the SQL statement stored in it. It goes something like this: Set rcd =...