Search results

Hi jmbreland, It's probably best to use a new thread rather than re-open a 4 year dormant one, but here's my suggestion for your issue: Place the button across the continuous form to get "focus" and trigger the form's onCurrent code. In the form>onCurrent, place the record ID into a text field...

I'm by no means a real expert, but would having an Index on the telephone numbers allow you to go through the 2 lists in incrementing order on each, only comparing the current pair? So, no1=lowest to highest new number to check no2 = lowest to highest existing numbers while (no1 > no2)...