How to run a update query automatically ?

[acnovice]

Hi,

I created one update query to update "Amount" field from InvoiceSubForm to InvoiceSubTable. "Amount" field is calculated "Q'ty x UnitPrice".
However, when I print report form, "Amount" field isn't updated automatically. So I go to Query and run that query and print report form.
Is there any way run the update query automatically ?

Thank you.

 

[jbpez]

You could do it with VBA, on the OnOpen event.

Private Sub Report_Open(Cancel As Integer)
'this will run the query
DoCmd.SetWarnings False
DoCmd.OpenQuery "QUERYNAME", acViewNormal
End sub

John Borges

 

[acnovice]

Hi Guys,

Thank you "jbpez"... it works perfectly.

Have a good day.

 

[GingerR]

Hey there acnovice....seems like jbpez deserves a star!?! A star goes a long way!!

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244