Run query based on data change in table

[Stu Morris]

I have an InfoPath form which submits and recieves data from an access table.
I want to do the calculations in Access, i am using a datediff function to
calculate the number of days between two dates. I want to have the query run
whenever data is written to the table?

Any suggestions greatly recieved
Stu

 

[Arvin Meyer [MVP]]

There is not such thing as a Trigger on an Access/Jet table. You must either
change your data engine to SQL-Server, or use Access forms which have proper
events for doing this.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Stu Morris]

Thats a shame
I have attempted to use the defult value in the table but without success
i dont have sql server and if i am not sure how this will impact on my
infopath form.

Is there no other way??

Stu