A
Ashley
querie but I have no idea what to do to get it working. I
have couple of tables, the important ones in this case are
the Appointments table and the Patients table. I also have
a form for the Appointments table and another one for the
Patients table. On the Patients form I have a command
button which opens up the Appointment form. In here the
user enters the information for the patients appointment .
Since the Appointments table strores the appointments of
all patients, what I want is for the Appointment form to
open up with only the previous appointment of that
patient, using the patients ID as the criteria I guess.
In other words the user will only see the appointments of
the patient which he was looking at in the Patients form.
Your main form is the Patient and the subform is
Appointment.
When you go to that patient you will see all appointments
related to that patient.
You can also create a lookup form to go to a particular
Patient when the main form open.
Hope this help!