Access autocomplete fields in access 2007?

[Uttar]

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 added in my drop down list its not display..no type in its first character, only display was my last list which i create..Add new ones was a problem

 

[wchelly]

Make sure the "new" value is in the list. Is it a value list or a table?

Then make sure your combo box is connected to the right list.

 

[Uttar]

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.

 

[wchelly]

Are you storing the Dropdown items in a table or as a value list?

 

[Uttar]

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..

 

[John Big Booty]

Perhaps the sample here will give you some pointers.

 

[Uttar]

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..

 

[John Big Booty]

That's pretty much what my sample demonstrates

 

[Uttar]

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 combine all tables