Hi,
Basically I need to design a form based on another table/form all I need to do is take 3 fields from a table/form called "Employee Details" the 3 fields I need are: "ID", "First Name" and "Last Name". When the first and last name are typed in I need the ID field to auto populate with results from the "Employee Details" (and maybe the possibility of a wild card on the first and last name to account for any incorrect spellings). The final thing is once the data has been seen and the form is no longer needed the data does not save anywhere
Cheers
Ben
Basically I need to design a form based on another table/form all I need to do is take 3 fields from a table/form called "Employee Details" the 3 fields I need are: "ID", "First Name" and "Last Name". When the first and last name are typed in I need the ID field to auto populate with results from the "Employee Details" (and maybe the possibility of a wild card on the first and last name to account for any incorrect spellings). The final thing is once the data has been seen and the form is no longer needed the data does not save anywhere
Cheers
Ben
