I have a form that I created and i have a text box on the form that will allow the user to enter the Retrieve Batch Number and if they hit the Find Record button this should show the information on the form that was entered. Under the Find Record button i have this query SELECT * FROM [CMAS-TEST] WHERE ((([CMAS-TEST].Batch_CMAS) Like [Forms]![Retrieve_Batch_CMAS]![Batch_CMAS] & "*")); however its working but not like i want it to work. What happen is when i enter the number in the Retrieve Batch Number and hit Find Record the database opens up and shows me the correct information but i want the information to show on the form. What I am doing wrong on this can someone help me?
Thanking You in Advance for you assistance on this matter.