Open on last record in subform

[Guest]

Using A2K, I have a form containing customer details and three subforms. One of the subforms can have multiple records, basically containing a log of appointments. What I would idealy like to do is, as you click onto the next record (or customer) in the main form it automatically opens on the last record (or in this case the most recent appointment) in the appointment subform for that customer.

Main form/table has CustID as Primary and the appointment subform/table has AppointmentID as Primary and CustID which is linked to the main form/table. Both Primary keys are Autonumber fields.

 

[Douglas J. Steele]

Why not base the subform on a query that sorts by appointment date
descending?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Using A2K, I have a form containing customer details and three subforms.

One of the subforms can have multiple records, basically containing a log of
appointments. What I would idealy like to do is, as you click onto the next
record (or customer) in the main form it automatically opens on the last
record (or in this case the most recent appointment) in the appointment
subform for that customer.

Main form/table has CustID as Primary and the appointment subform/table

has AppointmentID as Primary and CustID which is linked to the main
form/table. Both Primary keys are Autonumber fields.