Hey ppls,
pretty basic idea but im having trouble with the coding.
Table: [Stock]
I have a form based on Query: [NegStock] (which shows all stock items with value <0 and ignore is no)
with field
[ignore] (yes/no)
The form is looking at one record at a time.
I have a next record and previous record button .
What I want is to click ignore to YES and then go to next record but if I click back... that record is no longer there as it was selected as YES....
I have tried requerying the form and refreshing it but no luck at all... how on earth do I achieve this basic routine!!?
GAngel