First let me say thank you to those that patiently answer my questions! You make my struggles much easier!
Okay - today's question.
One form displays information from three files. Parent table stores ID # for corresponding record in child tables.
To explain my question, I'll use and example form:
Form displays customer record and related information from Sales People table and Shipping info table.
The user can select/change sales person info by selecting a name in a combo box. When the salesperson name is selected or changed the other salesperson information should be updated in the fields on the form. I thought that I should put ThisForm.Refresh() in the Interactive Change event but the information is not updateing.
Could you please help!
Thanks in advance.
Okay - today's question.
One form displays information from three files. Parent table stores ID # for corresponding record in child tables.
To explain my question, I'll use and example form:
Form displays customer record and related information from Sales People table and Shipping info table.
The user can select/change sales person info by selecting a name in a combo box. When the salesperson name is selected or changed the other salesperson information should be updated in the fields on the form. I thought that I should put ThisForm.Refresh() in the Interactive Change event but the information is not updateing.
Could you please help!
Thanks in advance.