On Sat, 27 Mar 2010 18:21:04 -0700 (PDT), Lostguy wrote:

tblDogVisit
tblDogVisitpk, autonumber
DogIDfk, number
VisitIDfk

tblVisit
VisitIDpk, Autonumber
VisitDate, Date/Time

I am working on the Record Source and Master/Child portion of your
response. Thanks for your time!

I'd simply put a date/time field in tblDogVisit rather than having an entire
table and form containing nothing but a date. You don't need to keep any
information that is specific to March 29, as a date, independent of any dogs
or visits. I think you're overnormalizing here!

You can certainly base a form on a query selecting a date or a range of dates.
--

John W. Vinson [MVP]