If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo Box
I have form in which I want to have a combo box. I wanted to avoid a query
and asked this question awhile back. Fred responded with a line of script which looks like this when I put in my table and field names. SELECT DISTINCT main.[priority] FROM main ORDER BY main.[priority] I put this in the row source of the combo box. One of three choices should appear in the drop down list: low, medium, and high. They do not appear, but when I type the first letter of any of the three choices, the field fills with that word. What am I missing to make the drop down box appear with these choices? |
#2
|
|||
|
|||
Combo Box
On Thu, 4 Feb 2010 11:55:01 -0800, Kyhigh wrote:
I have form in which I want to have a combo box. I wanted to avoid a query and asked this question awhile back. Fred responded with a line of script which looks like this when I put in my table and field names. SELECT DISTINCT main.[priority] FROM main ORDER BY main.[priority] I put this in the row source of the combo box. One of three choices should appear in the drop down list: low, medium, and high. They do not appear, but when I type the first letter of any of the three choices, the field fills with that word. What am I missing to make the drop down box appear with these choices? 1) What is the bound column property number value of the combo box? It should be 1. 2) What is the Column Widths property value? It should be something like this: 1" (any number except 0". 3) What version of Access are you using? If perhaps it is Access 2003 and you have installed Service Pack it could be the Service Pack 3 bug. See this link for details on the hotfix. http://support.microsoft.com/kb/945674 -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|