I have combobox problem

[pedie]

Hi, I have combobox problem...
I have combo source linked to table and when i load the form i can see the text but when i try to refer to combo value it returns the row number and not the text....why?

My table values
1. Jan
2. Feb
3. mar

I want the month name and not row/record number...

Thanks in advance for helping....
Pedie

 

[Norie]

What's the row source for the combobox?

 

[pedie]

What's the row source for the combobox?

It it table called Months
it looks like this...

[/FONT]
[FONT=Courier New]SELECT [Months].[ID], [Months].[MyMOnths] FROM Months;

Also one more thing i want my combo values to be all unique values, no duplicates...

Thanks Norie

 

[Norie]

Why are you including MonthID if you don't want it?

You could try removing it:

SELECT DISTINCT [Months].[MyMOnths] FROM [Months]

Not sure if that's what you want though.

Do you just want a combobox with Jan, Feb, Apr, May... Dec?

 

[pedie]

Norie, you can say..i do not know anything yet in access....

I tried this and now the value returned is blank in my Combobox

Please advice.

Pedie

Why are you including MonthID if you don't want it?

You could try removing it:

SELECT DISTINCT [Months].[MyMOnths] FROM [Months]

Not sure if that's what you want though.

Do you just want a combobox with Jan, Feb, Apr, May... Dec?

 

[Norie]

Try this.

Delete the existing combobox.

Check the control wizard is turned on:

Access 2010 (and 2007) - click the dropdown arrow to the right of all the controls in the Controls section of the main toolbar and select Use Control Wizards.

Earlier versions - check the small wand on the Control Toolbox.

One you've done that add a combobox to the form and you'll be guided through by the wizard.

By the way, how are you getting the value from the combobox anyway?

 

[pedie]

Norie, now it works cool! it was the small space i guess...
I tried new combobox and works perfect now...


Thanks again.

Try this.

Delete the existing combobox.

Check the control wizard is turned on:

Access 2010 (and 2007) - click the dropdown arrow to the right of all the controls in the Controls section of the main toolbar and select Use Control Wizards.

Earlier versions - check the small wand on the Control Toolbox.

One you've done that add a combobox to the form and you'll be guided through by the wizard.


By the way, how are you getting the value from the combobox anyway?

 

[Norie]

What 'small space'?

I'm pretty sure I know why it didn't work, the combobox had been set to 2 columns with the first column hidden.

So you would only see the 2nd column, which is the month.

The reason it returns the ID is because the bound column is set to return that.

 

[pedie]

Hi again, yep maybe not the spaces...
I deleted it and tried again...just pasted the line you provided in the source and it worked...
I also just realised we can use query for this combo...

Thanks again Norie.

What 'small space'?

I'm pretty sure I know why it didn't work, the combobox had been set to 2 columns with the first column hidden.

So you would only see the 2nd column, which is the month.

The reason it returns the ID is because the bound column is set to return that.

 

[Norie]

Pedie

You are using a query.

This is a query:

SELECT DISTINCT [Months].[MyMOnths] FROM [Months]