Not sure how to handle this.
User will select a file name from a combo box. The file selected is to be formatted, parsing the ID No., a 12-digit number, into three parts- "ID" (characters 1-6), "Location" (characters 7-9), and "SubLocation" (characters 10-12).
Should I use a query with the ID No. parameter being the combo box value After Update or can a query be written using code?
Please provide details. Thanks.
Richard...
User will select a file name from a combo box. The file selected is to be formatted, parsing the ID No., a 12-digit number, into three parts- "ID" (characters 1-6), "Location" (characters 7-9), and "SubLocation" (characters 10-12).
Should I use a query with the ID No. parameter being the combo box value After Update or can a query be written using code?
Please provide details. Thanks.
Richard...
