I want to automatically fill in a text box on my form based on the selection in the previous list box. I know how to do this in Oracle...love those post-text triggers...but can't seem to get it right in Access.
i.e. I have a Sales_Reps table with Rep_ID, Rep_name and Rep_phone (among others)...