Combo box display values

Question

hi

need help on combo box in my access 2007.i have been able to design my form but when i drop my combo box into my form, it does not display the values from my drop down list

can anyone show me each step from drag the drop down-box till it show the values from my  drop-down List

Answer 1

1. Open the form in design view.
2. Open the Properties sheet if it isn't already open.
3. Select the combo box.
4. look for the property called Row Source Type. Is it Value List or table/query?
5. Is anything listed on the line for Row Source?

---

Bill Mosca
www.thatlldoit.com
http://tech.groups.yahoo.com/group/MS_Access_Professionals

Answer 2

 thanks Bill..

 have been able to solve the issues regarding the above problems..:)

My second Question .in my department Name there a so many names  entered in text field my question like if i type my first letter 'P's i need to display all the 'P's as i entered in case what i entered is already stored..how can i solve that..

like the below link

http://support.google.com/websearch/bin/answer.py?hl=en&answer=106230

thanks

Answer 3

 thanks Bill..

 have been able to solve the issues regarding the above problems..:)

My second Question .in my department Name there a so many names  entered in text field my question like if i type my first letter 'P's i need to display all the 'P's as i entered in case what i entered is already stored..how can i solve that..

like the below link

http://support.google.com/websearch/bin/answer.py?hl=en&answer=106230

thanks

you can do this in the got focus event

me.cboboxname.dropdown

---

For the benefit of others, please mark posts as answered or helpful when they answer or assist you in finding the answer. ___ "We came all this way to explore the Moon, and the most important thing is that we discovered the Earth." - Bill Anders, Apollo 8.

Answer 4

hi suzyQ..

thanks for reply..i tried the code above it doesn't  work...i already type 'Test' but when i type in 'Te' it does not suggested 'Test' when i type in..I'm using Text box and not combo-box

thanks in advance..

Answer 5

well... a text box does not have the dropdown method.  If you're using a text box instead of a combo box - it could be why you didn't see anything in your original question.

---

For the benefit of others, please mark posts as answered or helpful when they answer or assist you in finding the answer. ___ "We came all this way to explore the Moon, and the most important thing is that we discovered the Earth." - Bill Anders, Apollo 8.