Update Query or Multiselect function??

[Therese]

I am trying to update information for multiple clients. For example, I may give 10 dogs a vaccine on the same day. I would like to enter the vaccination information (type, date given, expiration, etc...) and then select the 10 dogs names to update those records so that I only have to enter the information once. I have a form connected to a query using the In() function and can select the names, but I don't know how to keep those names and enter the information for the vaccine. Does that make sense?? Basically, I want to enter information once and have it apply to multiple clients. Oh yeah, The clients are in one table (dog names, etc...) and the vaccine info is in a seperate table (date given, type, etc...). I want the second table updated for each dog. Thanks.

Therese

 

[fernin8r]

UPDATE tbl_name SET type='val1', date given='val2', expiration='val3', etc... WHERE ID=dog1 OR ID=dog2 OR etc...


NOTES:
the VALUES () are the updated values for the corresponding fields in the field list. Example :

table: Data1

ID: 1
name: fluffy
type: bulldog
date: 10/11/04


if you wanted to change the 'type' and the 'date' fields, your query would be as follows

UPDATE Data1 SET type='hound dog', date1='11/01/01' WHERE ID=1;