Creating new records in subform

[Neil Hiorns]

I have a form in A2K that contains our customers addresses (linked to Customer table, with CustID as the primary key). Have a subform which contains schedule information, namely a date and time field for when a rep will visit them. This information is kept in a schedule table and has a SchedID (as primary) and CustID, which is used to link the subform to the main form.

I also have on the schedule subform some option buttons to indicate whether the appointment is the first or second appointment and also whether the appointment has been rescheduled.

What I woud like to do is, if an appointment is rescheduled or if a second appointment is booked, when the new date and time is booked a new record is created in the schedule table (perhaps using an 'update button'). It must not overwrite the original appointment record, as this is needed for tracking purposes.

I can get the form is work, but cannot find a way to create a new appointment record in the subform, which is still linked to each customer in the main form.

All suggestions welcomed.

 

[Neil Hiorns]

Please ignore posting, I was looking for a complex solution when the answer was simply to add Navigation Controls (which I previously disabled) to the subform. This obviously means I can add a new record.

Doh!