Copy records that meet certain criteria to another table

[thepope77]

Hi:

I have a database that contains test records. The testers key this information in and those data are written to one table. The records that are "good" are then copied via a macro to another table that only contains "good" data. ("Good" means that the record has met a certain set of criteria)

I want to automate this process. Ideally I would like to have code running behind a command button, for instance when the user clicks on "Test Next". I want to get far, far away from the macros.

Thanks a lot for the assistance.

 

[cheerio]

Are you able to create an Accss query that can select all the good records in the table?

 

[thepope77]

Yes. That is what I am doing in the macro. I am running a query that is picking out the good records.

Thanks.

 

[cheerio]

In that case the query can be converted from a select query to an append query. There is a drop down box on the query design screen. When an append query is run instead of showing the results they are appended to the target table.

 

[thepope77]

That is what I am doing now. I want to automate this process through VBA. That way I won't have to rely on a person to decide what is acceptable and what is not.

Thanks.