Search results

i have 3 tables and each has 3 forms...so when i type in new value in my form it able to updated and then added into my list in my drop down menu combo box..so my 3 forms i combine them into 1 form which has itemsID,ItemDesc,FacilityDesc,Shed Desc and Maxmum value...example when i update my new...

:) thanks john...i knw my problems now cause i dont have any FormItems..i only have have staff, items etc but i dnt create a form for each..the only form i have which has the final form which i have all table included..so that where i get it wrong.. my question you cant have only one Form to...

thanks John...im using ms access 2007 for your form you cant add new item to that combo box dropdownlist...i want to add new item so that it can be saved on my drop down list..that what im asking..

i've stored in a table name Items(ID,Desc)...so in mt Companyform i have a itemDesc dropdown list..when run the form click on my dropdownlist all my ItemDesc value all there but when try to add new value i cant..

if i add a new value, it doesn't display and not stored in my combo drop down list if i re-enter that text..only the data that i first create my table was already there..the good thing it was stored in my database but i want it to be display in my com box drop down list.

i have entered my values in my Department list..in my form i create a combo box which display all my Department Values..however i want to add a new department, when i add new department, click add button it saved in my database but when i go back to the form and find that new department to be...