Have Form A contains a text field where user enters a string and stores string to memory variable.
Have Form B whose record source is Query B.
Query B returns the following records:
User enters text in Form A. User clicks command button that opens Form B. Is there some way to open Form B to Color that matches string that user entered in Form A? Would like to navigate through all records in Form B, but open Form B to Color that matches string that user entered in Form A.
Know that I can filter on string entered by user, but that would prevent me from navigating through all records.