I have a lisbox with the rowSource set to : SELECT [Personal].ID, [Personal].Contact
FROM [Personal]
WHERE ((([Personal].Contact) Like "A" & "*")
This returns all the A's in my Table. I need to refine my search with a textbox[Text2] where i can search my records by data i input in the text box!! For example if I Type "Ar": I would like to see only those records starting with "Ar".
I've tried : Like "'*" & [Forms]![ form name here]![control name here] & "*'" With no Luck!!
Could use some help ...Rodney
FROM [Personal]
WHERE ((([Personal].Contact) Like "A" & "*")
This returns all the A's in my Table. I need to refine my search with a textbox[Text2] where i can search my records by data i input in the text box!! For example if I Type "Ar": I would like to see only those records starting with "Ar".
I've tried : Like "'*" & [Forms]![ form name here]![control name here] & "*'" With no Luck!!
Could use some help ...Rodney