On the close property of a report I want to write some code that would update a field in a table to 'PAID' where the same field in the same table is 'OS' and where 2 fields in an existing query (not the same query used to create the report) are equal.
My problem is reference the query. Can I do that in VB?
update table1 set Status = 'PAID' where [table1].[status] = 'OS' and [query1].[totrecamt] = [query1].[ipprem]
I tried the above, but I am being prompted to enter amounts for totrecamt and ipprem.