Append Query from Event 'After Update'

[IKMD66]

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

 

[Jeanette Cunningham]

Kirk,
you can learn how to do it by following steps like these.
Create a new query - use the table that has the field TutorID and drag the
field TutorID on to the grid.
Choose Query on the menu and change it to an append query.
Choose the table you wish to append to.
Now switch to SQL view and copy and paste the code into the appropriate
place in the code you are writing for the after update.
You will need to tweak the sql to suit the code editor, but you have a very
good start to work from.
You can requery the form that needs to show the appended record.


Jeanette Cunningham -- Melbourne Victoria Australia