Hello, everyone.
I’m trying to create a form to edit a “current inventory table.” What I want to do is open a form with a subform embedded based on a query. This box shows all current assets in the table.
Right above this subform, I have a text box and a button labeled “Search.” When Search is clicked, I was to run a query against all columns of data in the table and return the results in the subform (allowing editing of this returned data).
I tried adding criteria o “tblCurrentAssets.*” but Access states I cannot run criteria against “*”. Please help, or offer any alternative solutions. Thank you very much in advance.
