Display Query on a form

[CurtR]

I have a simple database, 2 tables. One is the contact table
one is the service calls table. Linked by ContactID

Being that each contact can have multiple calls I wanted to create a query to display on the contacts form showing the latest call date from the service calls table for the contact being displayed.

I have a query that works. Using the latest function of Access and where the Contacts.ContactID = Calls.ContactID

While I am still researching how to do this I thought I would ask too.

Thanks for any help
Curt

 

[dhookom]

You typically would create a continuous form to use a subform. You can use the Link Master/Child properties of the subform control to filter the subform records to a value in the main form.

Duane
Hook'D on Access
MS Access MVP