Hi,
I have the following issue and I can't find a satisfactory solution. Pls note I have not looked into VBA to solve this, so I might missed the obvious solution.
I have a form, where I store all details about a site, including the parent company name. The original version of the db, which was done by somebody else, I have a combo box, where parent company can be selected by name. Once it is selected, it goes to a LOOKUP field on the Site table, than by some magic, the Company Name field is populated in the same table. There is also a hidden field for the Company Name on the original form.
I replicated everything on the original way, but it is not working,
I tried to use the Combo Box, selecting the option to look up details from a different table, then selected the Parent Company ID and Name and I selected to store this to the Parent Company field on the Site table. Got the combo box and the ID is save into the right place, but I can't put the name into that field.
I created an other combo box on the same form, selecting the sales employee, did the same steps and the name is appearing in the Site Details table .
Do you have any idea what do I do wrong?
Your help would be much appreciated.
I have the following issue and I can't find a satisfactory solution. Pls note I have not looked into VBA to solve this, so I might missed the obvious solution.
I have a form, where I store all details about a site, including the parent company name. The original version of the db, which was done by somebody else, I have a combo box, where parent company can be selected by name. Once it is selected, it goes to a LOOKUP field on the Site table, than by some magic, the Company Name field is populated in the same table. There is also a hidden field for the Company Name on the original form.
I replicated everything on the original way, but it is not working,
I tried to use the Combo Box, selecting the option to look up details from a different table, then selected the Parent Company ID and Name and I selected to store this to the Parent Company field on the Site table. Got the combo box and the ID is save into the right place, but I can't put the name into that field.
I created an other combo box on the same form, selecting the sales employee, did the same steps and the name is appearing in the Site Details table .
Do you have any idea what do I do wrong?
Your help would be much appreciated.