How to reference every record in Continuous forms?

D

DrEvil

Hi guys,
I have question regarding picking up values from specific field (CaseNo)
from continuous form and running update query based on those cases. Here is
my situation;
I have continuous form called frmReceive and CaseNo is one othe the fields..
Now employee will enter bunch of cases in the form in addition to some other
things and what happens now is when you exit out of the current record it
will run update query based on that CaseNo, CaseNo is acting as a filter in
this case and updates some flags for previous entries for that case. That all
works just fine but we ran in to a problem if user enters CaseNo by mistake
and meant to receive something else and since he is out of the record the
update query has already ran and made it's changes.
Now, what I was thinking is doing this update on exit but I'm unable to get
all these CaseNo's from continuous form to act as a filter in an update
query. Query is called qryUpdatingCurIndicator, here is the VB code;

UPDATE tblfileloc SET tblfileloc.CurrentIndicator = "N"
WHERE (((tblfileloc.CurrentIndicator)="Y") AND
((tblfileloc.CaseNo)=[forms]![frmReceive]![CaseNo]));

Any help would be greatly appreciated.
 
Top