i have created a split form and added a textbox to search for a particular data on the datasheet. The button on which i have applied a macro to search for particular data is working fine but it generates a problem. When i search for a text it displays the data in datasheet view but after clearing the textbox the datasheet view does not display the full list of all the data.
here is code i added in the Macro Builder of the button
="Passport_Number = '" & [Forms]![Client_Details]![searchtxt] & "'"
kidnly tell how to display all the data back in datasheet of the split form after the search is complete. Thanks
here is code i added in the Macro Builder of the button
="Passport_Number = '" & [Forms]![Client_Details]![searchtxt] & "'"
kidnly tell how to display all the data back in datasheet of the split form after the search is complete. Thanks