Hi,
I have a main form which is used for entering records into a main table. I know how to use filter by form, that little icon, to filter out the records based on a certain criteria. However, my not-for-profit customer thinks too many steps are involved with this. She wants a command button that when clicked, executes a message box in which she can type the name into. Then, she wants that name filtered and shown on the main form until she hits another button to kill the filter and return back to the unfiltered form. I have tried this and it works well. However, it shows the raw filtered data on the typical default table view. I cannot seem to get the data to show up on the actual form itself, such as how it would show up if I used the filter by form icon. If someone can please help me, I would greatly appreciate it!! Thank you.
I have a main form which is used for entering records into a main table. I know how to use filter by form, that little icon, to filter out the records based on a certain criteria. However, my not-for-profit customer thinks too many steps are involved with this. She wants a command button that when clicked, executes a message box in which she can type the name into. Then, she wants that name filtered and shown on the main form until she hits another button to kill the filter and return back to the unfiltered form. I have tried this and it works well. However, it shows the raw filtered data on the typical default table view. I cannot seem to get the data to show up on the actual form itself, such as how it would show up if I used the filter by form icon. If someone can please help me, I would greatly appreciate it!! Thank you.
