Need some help in tackling a problem.
Devised a form that allows the user to add company information however to keep data clean the company field is a look up table to a Company table that stores company information. In instances when they add a record for a NEW company, not in the company table i have arranged for a form to open as a result of a macro in the company control using "On not in list".
This is fine as a company form opens however when a new company is entered this does not appear on the original input form. It only appears if the original form is closed and re-opened.
Not sure if this makes much sense however i am hoping that someone can help.
Excuse me if this is not clear and i may not be using correct terminology.
Thanks in advance
Devised a form that allows the user to add company information however to keep data clean the company field is a look up table to a Company table that stores company information. In instances when they add a record for a NEW company, not in the company table i have arranged for a form to open as a result of a macro in the company control using "On not in list".
This is fine as a company form opens however when a new company is entered this does not appear on the original input form. It only appears if the original form is closed and re-opened.
Not sure if this makes much sense however i am hoping that someone can help.
Excuse me if this is not clear and i may not be using correct terminology.
Thanks in advance