Could I use this macro to have a user insert multiple ID numbers to search a split form and return a list of results for each ID number entered?
For example, the user would enter multiple IDs (medical record numbers) separated by a comma or a space and the data sheet of the split form would show only the entries for those specific IDs.