May 23 2012, 08:25 AM
In a continues form i want to highlight if the values in text field A is similar to previous or next record (Field A). Is this possible? And in that case, how do i proceed?
May 23 2012, 08:48 AM
You would have to have a means of identifying the previous record using a value in that record that can be derived from the current record.
So if you have a continuous sequence of ID numbers presented in the form then you can use ID-1 to identify the ID of the previous record.
if the sequence is not complete then you might be able to use a max()/DMax() function to identifty the id of the previous record.
But every case has to be custom built to its situation. There is no general way of referring to other records.
Also, you have to consider what happens if the user is allowed to sort the data into a sequence you were not expecting.
May 23 2012, 09:01 AM
Thanks Peter46, seems to be a hustle. Perhaps better to just sort that specific field in desending / ascending order and let the user identify the equal values..
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here