Ok, here are some questions:
A) Where does this code go, in the Click event?
B) How do I actually execute the query?
C) When does the Append Query come into play?
D) What is the purpose of the Pass Through Query; why not just modify and execute the Append Query?
E) I don't want to "hard code" anything, I want to use the Item Number field on the form in the WHERE clause of the SQL statement. You know, a user enters an Item Number into a field on a form; the SQL fetches the data from the AS400 based on the Item Number entered, and populates fields(columns) in the appropriate Access table. Simple and basic.
A) Where does this code go, in the Click event?
B) How do I actually execute the query?
C) When does the Append Query come into play?
D) What is the purpose of the Pass Through Query; why not just modify and execute the Append Query?
E) I don't want to "hard code" anything, I want to use the Item Number field on the form in the WHERE clause of the SQL statement. You know, a user enters an Item Number into a field on a form; the SQL fetches the data from the AS400 based on the Item Number entered, and populates fields(columns) in the appropriate Access table. Simple and basic.