I am working with one Form and have setup some of the fields as combo boxes that use the row Source Type and Row Source Properties. It allows the user to type the first part of a name and finds the rest in the drop down list. Is there a way to have one field, (say for example the Name) lookup other field values???? If the user finds Company Name ABC, once that value is selected, it does a lookup for the rest of the info, Address, City, State, Zip and Phone?
Thanks
David
Thanks
David