how do you insert a set of new records based on a condition?

[jeetrix]

This is my problem:

I have two tables, people and memebrships.
people has a field, individual member

i want a button that does the following:

if you push it a year number (eg.2004) is read from an input field and for each record in people with individualmember=yes a record has to be added in memberships using that year number and some data of the record

any ideas?

tnx!

 

[Crilen007]

I didnt quite understand what you wanted..

 

[JACKSON]

Write an Append Query and include that field with a criteria. Create a command button that runs the query, and reference a field on your form in the query criteria that has the value you want to use as your filter.