Truthfully, I'm confused about what you're trying to accomplish.
If you're simply trying to display the Min(date) from table notes as it relates to the currently displayed record from table Main, you might try building a subform that has your "Select Min(date)..." query as the record source. The subform will be linked to the main form using Link Master field of "id" and Link Child field of "notes.id".
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group