I'm using Access 2010 on Wind 7.
I have a Db with 2 tables. the form duplicates each field in the Tbl.
Its a "Data Entry" recording of hard copies of many peoples records. Sometimes they make mistakes. So I have to enter as reported, and fix mistakes at a later time. So I have a "Yes/No" check box to identify which record are "Right" and which are "Wrong".
I would like 1 Form to do 2 things.
1) Populate data into the table.
While doing that I identify which records are in error with the "check box" control. (un-bound) This works fine.
2) I'd like to be able to open the same form (showing all the records) and then click a button and run a Query to select just the erroneous records.
My button works fine too, but opens the "Data Sheet" view of the table.
I'd like to remain in the "Form View" and correct the records.
One of the Form users recommended I enter "QueryName" in the RecordSource spot in Properties but that opens the "Form" after the "Query" has run. :-(
I have a Db with 2 tables. the form duplicates each field in the Tbl.
Its a "Data Entry" recording of hard copies of many peoples records. Sometimes they make mistakes. So I have to enter as reported, and fix mistakes at a later time. So I have a "Yes/No" check box to identify which record are "Right" and which are "Wrong".
I would like 1 Form to do 2 things.
1) Populate data into the table.
While doing that I identify which records are in error with the "check box" control. (un-bound) This works fine.
2) I'd like to be able to open the same form (showing all the records) and then click a button and run a Query to select just the erroneous records.
My button works fine too, but opens the "Data Sheet" view of the table.
I'd like to remain in the "Form View" and correct the records.
One of the Form users recommended I enter "QueryName" in the RecordSource spot in Properties but that opens the "Form" after the "Query" has run. :-(
