I can not for the life of me figure out how to Type in a Customer Name or Part of a Customer Name, Click findRecord_btn and it show the results in the CF_Result_sub form. and If there are no matching records then Show Label53. Here is what I am working with. Any help would be of great value!!!
MSACCESS 2002
Table: Customer_tbl
Fields: Customer_ID, First Name, Last Name
Main Form: FindCustomer_form
Fields: firstName_txt " This is where the customer would type in a customer first name like, (Justin, Just, Ju, or J)
Button: findRecord_btn "This is the button to search Records"
Label53: "Simply states, No Customers Found."
Sub Form: CF_Results_sub "This will show every record that matches "Justin, just, ju, or j"
On the subform I have three fields that have the (Customer_ID, First Name, and Last Name)