On Tue, 30 Mar 2010 14:58:01 -0700, daisy
wrote:

thank you how would the form pull in data associated with it that is older
than the current data?

By using appropriate criteria. Since I know nothing about your "current data",
nor the structure of your table, nor exactly what you're looking for it's a
bit hard to give a specific answer! For data with a datefield prior to today's
date, you can use

Date()

on the criteria line.
--

John W. Vinson [MVP]