Im creating a Command Button on a Form that displays data from a table(Name,Address,State,number) etc what do i need to do for the user to get a prompt so in the name field he can type a name and recive all the results corresponding to that persons name. and not everyones name
I Like Pie!
SELECT tblName.Name, tblName.Address, tblName.State, tblName.Number
WHERE (((tblName.Name) Like "*" & [Enter Name Here?] & "*"));
This is a Parameter Query, ive put tblName as the Name of your Table