Still Problems with Combo Box

[damaruk]

I am still having problems with a combo box on a form. The colomn rerference is set right and on the form the Mr Mrs Miss etc are displayed correctly. My problem is when I do a query on a table for a mailshot the number appears before the personsname rather than the mr mrs etc

Would welcome any sugestions

regards
Mark [sig][/sig]

 

[PaulF]

if you post the Row Source Type & Row Source data for the combobox, it would be easier to assist you



PaulF
[sig][/sig]

 

[damaruk]

PAUL

Row Source type for combo box is TABLE/Query

Row Source Data is SELECT DISTINCTROW[TITLE].[ID],[TITLE].[TITLE]FROM[TITLE];

Regards
Mark [sig][/sig]

 

[PaulF]

What are the Values for the combobox
Column Count (should be set to 2)
Bound Column (should be set to 2)

if this is not the case then you need to change it to the above, and any records that you may have appended to your table will need to be updated accordingly.

PaulF [sig][/sig]

 

[jfhewitt]

Am I missing something, or have you complicated this beyond belief? Just create a combo box, type in the values that you want (Mr, Mrs,Ms), use only one column. You will have no problems, trust me. [sig][/sig]

 

[Guest_imported]

Just to soften the last post, if the Title table is just used for Mr. or Mrs etc... then there is no need for an ID column. You only want several choices of titles and by using the Title as the index you wont get any dups.

That might help!

John [sig]<p>John A. Gilman<br><a href=mailto:gms@uslink.net>gms@uslink.net</a><br>[/sig]

 

[rhicks]

For such few possible choices, you may also want to consider using a value list instead of a table/query as the Row Source Type. This would reduce the overhead of the db.

HTH s-)
RDH [sig]<p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br> [/sig]

 

[damaruk]

hank you all for your help

mark [sig][/sig]

 

[schwarz]

If you do want to work with an ID column, but you don't want to see it, set columnwidth to 0 for the first column and columnwidth of second column to non zero.
(e.g. properties of combo - column widths - 0cm;8.863cm)

Don't forget to specify which of the two columns you want to be bound.

If you want to [sig][/sig]

 

[schwarz]

If you do want to work with an ID column, but you don't want to see it, set columnwidth to 0 for the first column and columnwidth of second column to non zero.
(e.g. properties of combo - column widths - 0cm;8.863cm)

Don't forget to specify which of the two columns you want to be bound.

If you want to &quot;remember&quot; the ID column then set bound column = 1 else set bound colum = 2.

Carl

[sig][/sig]

 

[damaruk]

Thanks Carl for your help. It is appreciated

Mark [sig][/sig]

 

[3587]

Have you looked at

http://www.microsoft.com/office/sup/support.asp?lu=1&prd=access

[sig][/sig]