Ok, so I would need to give the field in my form a control that is a query.The query should include a inner join between the the table and colMatches from the following vba:
Set colMatches = objRegExp.Execute(myString) ' Execute search.
For Each objMatch In colMatches ' Iterate...
I would like to user Regex to to parse out additional digits in a scanned barcode and compare the result to the data in a column of a separate table.
Example
Scanned barcode: 030076126007348
Table contains: 761260073
I was able to find how to for the regex evaluation but not how to take the...