I have a table w/ two columns of information. Column 1 is an item number and column 2 is a description. I want Access to auto fill the column 2 information in a form once the column 1 information is selected from drop down list.
You can base the form on a query, have table one from your form and table two from an index. Once you have both values linked (that is the field in table one should be a look up wizzard to the first value in table two) if you select the first then the second should appear.
Comment