MSAccess: I have a form that lists columns from a table in a continuous form:
field1 field2 field3 field4 field5 .... (can display up to 10000 records)
The user can request that a string contained in field2 be changed to "CCDD" and display the new string in field3 before actually committing it to the db via a cmdSubmit button. My question is this: I developed a pop up to enable the user to note the old and new string. They close the popup via an OK button. I then pass the old and new string back to the main form. Please forgive me if this is a dumb question but how do I go through all the records on the form, look for the string in field2 and display the proposed change in field3. I know how to do it in VB with a grid but I've never done it in an MSAccess form. Thank you in advance.