combo box value list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a combo box containing a list of post titles. The post
titles can be found in the postdetails tbl. However, because this is a table
of all the posts in the company, then the post title can be listed many times.

eg a post title 'support worker' is what I want in the combo box. however in
the post details table there are 100 posts with the title 'support worker'.
How do I get the title to appear just once in the combo box?

hope this makes sense
regards
 
I would like to create a combo box containing a list of post titles. The post
titles can be found in the postdetails tbl. However, because this is a table
of all the posts in the company, then the post title can be listed many times.

eg a post title 'support worker' is what I want in the combo box. however in
the post details table there are 100 posts with the title 'support worker'.
How do I get the title to appear just once in the combo box?

hope this makes sense
regards
Click to expand...

SELECT DISTINCT(ROW) may be the key you are looking at
 
Lynn -- There are several ways to allow you to achieve your desired results.

One is to set the Row Source Type property of the combo box to 'Value List'
and to type in the values possible in the row source. This is probably not
ideal, particularly if there are a lot of possible values or if new post
titles are created frequently.

An alternative solution is set the Row Source Type property to Table/Query
and enter a similar query as the Row Source for the combo box:

SELECT DISTINCT post_title_field FROM post_detail_table;

This should select only the unique values in the post title field for the
combo box.

HTH!
 
Thanks for the replies.
this has the desired effect. However, it has thrown up a new problem which
is puzzling me. When I look at the list of values in the combo box, the post
of 'support worker' does not appear. If I look at the table or type 'support
worker' in the filter screen it does exist. Why is it not appearing on my
combo list?
Any ideas?
 
Thanks for the replies.
this has the desired effect. However, it has thrown up a new problem which
is puzzling me. When I look at the list of values in the combo box, the post
of 'support worker' does not appear. If I look at the table or type 'support
worker' in the filter screen it does exist. Why is it not appearing on my
combo list?
Any ideas?
Click to expand...
without seeing your SQL String it's imposible
 
thanks for the replies. I have put it in to practice and it works. I have
also answered my own question in a previous post. The problem was due to a
corrupt record.
 
sorted the problem by getting rid of a corrupt record which happened to be
the first in the missing category. If my fix for the corruption is stable,
then all is well.

thanks
 
Back
Top