I have a DAP accessing one table of my database, there is a dropdown list on this page and the values are coming from a query I built(the query pulls five pieces of information. When an item is selected from the dropdown list I would like four other text fields to be auto populated from information in that query. An example would be if you select a persons last name: the first name, address, city, and state field will auto populate from the query.
In my forms I do this by calling the column such as "txtState = cboLastName.column(1)" because my query pulls all that info and shows it in the access form drop down list.
In my forms I do this by calling the column such as "txtState = cboLastName.column(1)" because my query pulls all that info and shows it in the access form drop down list.