Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Macros should be avoided whenever possible. Many times they are not necessary. Have attached sample which uses a list box and a table filter to select the wanted company. Two forms are included. One without a macro which after selection requires you to press the button to retrieve the customer. The second form uses a very small macro to automatically retrieve the customer from the selection without a button.

This type of situation can easily be adopted to your requirements.

Sample: SelectCompanyByFilter2.odb

If this answers your question please click on the ✔ (upper left area of answer).

Macros should be avoided whenever possible. Many times they are not necessary. Have attached sample which uses a list box and a table filter to select the wanted company. Two forms are included. One without a macro which after selection requires you to press the button to retrieve the customer. The second form uses a very small macro to automatically retrieve the customer from the selection without a button.

This type of situation can easily be adopted to your requirements.

Sample: SelectCompanyByFilter2.odb

If this answers your question please click on the ✔ (upper left area of answer).