Hi,

Hopefully someone can assist.I need to run an Apphend Query using the Event
'After Update' - I have already assigned the query and it works, however I
need to be specific, in terns of the records it appends. The scenario is that
I have a tabbed form - main form and subforms. The first tab contains basic
data, when populated (data inserted in Tutor Table I need to append a record
in a seperate table for Tutor availability for the specified tutor.

Example
Tutor 6 is created in the basic data table when inserted I want access to
append a record, containing default data, to the tutor availability table
using [Tutor ID] as [Ref Tutor ID] - how do I get the query to be specific
like this?

One more thing - after the append qury is functioned I want the data in the
form to be 'Refreshed' somehow so that when the user click the availbility
tab the defaults are already there.

Would be grateful of any assistance.

Cheers,
Kirk