i have a table called input and a "form" input made on top of that same table.
when i input the data on the form it updates properly no issues.
i have another table main. i update the vendor name using combo box from main.
it works like that.
SELECT main.[Vendor Number], main.[Vendor Name]
FROM main;
and i update the vendor name using control source =vendorname.column(1)
i have even achieved the same thing using DlookUp .
the problem is that it saves on the Form but the data from Dlookup or from comboBox updates for "Vendoe Nmae" is not saved in input table.
hope i have explained the problem .
i am novice user. and stuck very badly. a quick reply will be highly apreciated.
Regards
A learner