What about
DoCmd.OpenForm "Appointments", , , "[customer]='" & customer & "'"
This limits the form to display only those for the customer.
In the "All" properties for the form, dont allow additions or deletions.
Since each customer only has one appointment, the appointment data should be in...