Hi,
I have a form that certain fields are returned from a temporary table (that the contents are firstly deleted and then refreshed every 5 minutes).
this causes the 3 fields to show #Deleted until a timer then refreshes the forms query.
The form does work really well and is 10x quicker than my old form using subforms rather than temp tables.
It does however cause this #Deleted issue (until the re-query kicks in).
Im wanting to increase the checking timer dramatically, but in order to do this, I only want the re-query to happen if it finds a #Deleted (rather than blindly re-querying when not needed).
Any help would be greatly appreciated.
I have a form that certain fields are returned from a temporary table (that the contents are firstly deleted and then refreshed every 5 minutes).
this causes the 3 fields to show #Deleted until a timer then refreshes the forms query.
The form does work really well and is 10x quicker than my old form using subforms rather than temp tables.
It does however cause this #Deleted issue (until the re-query kicks in).
Im wanting to increase the checking timer dramatically, but in order to do this, I only want the re-query to happen if it finds a #Deleted (rather than blindly re-querying when not needed).
Any help would be greatly appreciated.