A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combo Box



 
 
Thread Tools Display Modes
  #1  
Old February 4th, 2010, 08:55 PM posted to microsoft.public.access.forms
kyhigh
external usenet poster
 
Posts: 13
Default 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  
Old February 4th, 2010, 11:52 PM posted to microsoft.public.access.forms
fredg
external usenet poster
 
Posts: 4,386
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.