I need to make a homemade Search form for my users....one that they can press a button type in lastname or TM#, FirstName or SSN and BAM!!!!!! theres the results populated on the form. Anyone know of any good sites where I can obtain some info on how to create one of these or something??
I Used  in queries and it would ask me for parameters, cant seem to do that with an adp though. Trying to create a search form by using the LIKE parameter in an SQL statement for ADP. Perhaps a Search Field
Well its for two seperate tables The TERMINATION table and the EmployeeGamingLicense tables both of which have several fields but I only want the users to search by FirstName,Lastname,SSN or TM# and thats about it for now. Heres what one of the forms looks like
Brett when you say selection screen do you mean like a switchboard like this one??? I created my own homemade version of a switchboard since I used the DTS to transfer the data over to sql. I'll take your advice and fix the labels