form or query help

[combine21]

When an animal is moved from field to field, a new entry for each animal usually has to be made. In this form_movement, there are the fields animal ID, location, comments, and status (its checked if that where the animal is currently located). How would I go about creating a query or form in which I dont have to go to every animal and change their location, but only pull up the current room and make a new record for locations and it would know to place a record in each animals movement history? I hope that makes sense.

[RuralGuy]

Would it help if you have a HERD table and assign each animal to a HERD and then move the herd?

[combine21]

I went about it another way to get what I wanted for this issue.

[RuralGuy]

There are lots of ways to skin a cat in Access. Would you care to share your solution with the others that read this thread?