I have a list of contacts in a contact table. I also have a scheduler table that contains appointment dates for each contact. I've created a relationship between the two tables for ContactID.
I've created two bound forms - one for each table. When the user clicks on my "Scheduler" button on the contact details form, its currently running a macro that has the following for the Where clause:
="[ContactID=" & [ContactID]
The Action parameter of the macro is "open form"
I can tell the system is doing something because when I select a certain contact and then click on the scheduler button, the scheduler form loads but the appointment details for the contact doesn't appear. I know an appointment exists because if i remove the where clause and load all records, it appears.
I've checked to make sure that each field on the scheduler form is bound to their respective fields on the table.
I'm probably messing up on something really simple. Sorry for the troubles.
I've created two bound forms - one for each table. When the user clicks on my "Scheduler" button on the contact details form, its currently running a macro that has the following for the Where clause:
="[ContactID=" & [ContactID]
The Action parameter of the macro is "open form"
I can tell the system is doing something because when I select a certain contact and then click on the scheduler button, the scheduler form loads but the appointment details for the contact doesn't appear. I know an appointment exists because if i remove the where clause and load all records, it appears.
I've checked to make sure that each field on the scheduler form is bound to their respective fields on the table.
I'm probably messing up on something really simple. Sorry for the troubles.
