insert a record for all the ppl listed in a related table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi i have a list of ppl in my form based on a query and in the form i have a
subform connected. I want the same record to be filled out for each of the
clients in the form is there any way to do this by the mere press of a
button, rather than going to every person and putting in the same record.

I can tell you what the fields that need to get filled out are.

Month - this needs to get filled in as 1-Current Month-Current Year (eg so
if i would be filling it out today i would write 1-February-06)

and all the other fields get filled in either by default or dont need
filling in.

so is there any way i can do this, please can someone help me or at least
tell me if theres no possible way!
thanks a lot
 
An Append query would do that for you. In the Click Event of the command
button, establish the values you want for each record, define the filtering
so that only the clients in the subform are affected, and executue the query.
 
Back
Top