Is your data configured so that you can search on a calf ID number and then
change the date in a different column? You neglected to describe your
database layout, so it is difficult to offer a solution.

"M.Desmond" wrote:

I am using an excel database and have created a program to add and delete new
entries. Its a system of keeping track of Calf Vaccinations here at Cal
Poly's dairy unit. I am now attmepting to make some possible listbox form
that is populated by a due vaccinations pivot table that I can update all the
selected calves in the database at once that just recieved vaccinations that
day.
The problem is I am having a horrible time with writing VBA to "find" and
add new date to first empty row in "found" calf in the database.

Sorry if this sounds really confusing, any help you be greatly appreciated