I have a table1 with over 100 fields and 170 records.
I have form1, referenced to table1, that has 10 fields and all of the records in tabular form. There is a filter feature that effectively filters the data based on combo and text boxes.
I have form2, referenced to table1, that has all of the fields.
I would like to be able to use the filter on form1 then use a command button (or any easy way) to pull up the filtered results on form2. Is this possible?
The only useful thing I found would be referring to FindRecord or GoToRecord, but I'm not sure how to use these commands or if they would work for what I want.
Any help would be greatly appreciated!
I have form1, referenced to table1, that has 10 fields and all of the records in tabular form. There is a filter feature that effectively filters the data based on combo and text boxes.
I have form2, referenced to table1, that has all of the fields.
I would like to be able to use the filter on form1 then use a command button (or any easy way) to pull up the filtered results on form2. Is this possible?
The only useful thing I found would be referring to FindRecord or GoToRecord, but I'm not sure how to use these commands or if they would work for what I want.
Any help would be greatly appreciated!
