When I use the DoCmd.FindRecord it doesn't find the first record but it can find all the other ones? Why is it skipping the first record?

If you're using the DoCmd.FindRecord in a loop, put this before the loop starts:

DoCmd.MoveFirst

or

DoCmd.FindFirst "your criteria here"

The former will move your pointer up to the top first. The latter will do the same and then do the first search of your criteria.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division