Peter, you are awsome. I've been at this for over a week. I created a bunch of queries and tried to get the data using openquery and applyfilter. Everytime I tried, I just got errors and couldn't get the field to autofill. I compltely forgot about Dlookup. I simply pulled the data from the...