Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

In edit mode, bring up the properties for the List Box. On the Data tab, set 'Type of list contents' = Table, under 'List Content' use dropdown to select the table where the addresses are, and finally under 'Bound field' enter the field position of the address. 'Bound field' is an index so the first field in the table with addresses is 0, the second field is 1 and so on. Save your changes.

In edit mode, bring up the properties for the List Box. On the Data tab, set 'Type of list contents' = Table, under 'List Content' use dropdown to select the table where the addresses are, and finally under 'Bound field' enter the field position of the address. 'Bound field' is an index so the first field in the table with addresses is 0, the second field is 1 and so on. Save your changes.changes. In connection with the comments, I've modified my understanding of the question. To better understand my comment regarding a working model I include a sample here:CreditCardFilter.odb. Both forms work the same. Only significance is to show address table control on form is not needed to complete. After selecting a customer, click button. Choices in CUSTADDR field is a list box displaying only addresses for that customer.

In edit mode, bring up the properties for the List Box. On the Data tab, set 'Type of list contents' = Table, under 'List Content' use dropdown to select the table where the addresses are, and finally under 'Bound field' enter the field position of the address. 'Bound field' is an index so the first field in the table with addresses is 0, the second field is 1 and so on. Save your changes.

In connection with the comments, I've modified my understanding of the question. To better understand my comment regarding a working model I include a sample here:CreditCardFilter.odb. Both forms work the same. Only significance is to show address table control on form is not needed to complete. After selecting a customer, click button. Choices in CUSTADDR field is a list box displaying only addresses for that customer.

In edit mode, bring up the properties for the List Box. On the Data tab, set 'Type of list contents' = Table, under 'List Content' use dropdown to select the table where the addresses are, and finally under 'Bound field' enter the field position of the address. 'Bound field' is an index so the first field in the table with addresses is 0, the second field is 1 and so on. Save your changes.

In connection with the comments, I've modified my understanding of the question. To better understand my comment regarding a working model I include a sample here:CreditCardFilter.odbhere: PayMethodFilter.odb. Both forms work the same. Only significance is to show address table control on form is not needed to complete. After selecting a customer, click button. Choices in CUSTADDR field is a list box displaying only addresses for that customer.