Form Filters from form called with cmdButton

[sstiebinger]

I'm trying to open a form listing appointments from a button on a form for contacts.



I'd like the appointments form to be filtered to the contact displayed on the calling form, but I can't quite understand how to set this up.


Contacts form has Field [ID] which is primary key to the record.
Appointments form has field [ApptContact] which is foreign key reference to the contacts [ID] field.

Basically I want to call frmAppointments to display only items where [ApptContact] = me.ID with ME being the contacts form containing the button.

... I'm pretty new to Access and databases in general so please forgive my rudimentary phrasing.

[sstiebinger]

Opened it with VBA instead of trying to use the event builder...

DoCmd.OpenForm "frmAppointments", acFormDS, , "ApptContact =" & Me.ID, acFormReadOnly