Creating Combo box not all available fields are present

[rhett7660]

Hi all..

I am trying to put a combo drop down box on my form. The form is not based off a table or query. It is just going to be used for generating reports.

When I use the combo box tool and I have it look up a query. It only shows the PK for that query. Their are two fields in the query thou.

qryluTblReason
ReasonID (pk)
Reason

It is only showing me ReasonID, so the drop down is only giving me the numbers. Usually it shows me all the fields I can choose from. I have tried to set the column count on a hope that it would shoe me column two but it didn't.

Can someone tell me what I did wrong?

I have attached a stripped down version.

R~

 

[RuralGuy]

If you are talking about the frmSubMain ComboBox, it seems to be working just fine.

 

[rhett7660]

Rural Guy..

Sorry I forgot to mention, I was trying to put the combo box on the form frmReports. When I ever I put the combo box on the form and use the wizard I am only able to see one of the fields and it is usually the (pk) only.

R~

 

[RuralGuy]

It might be because the Wizard does not like making a Memo field available in a ComboBox. It will truncate the field at best. You can modify the ComboBox afterwords so that the Memo field will show but as I said, it is probably not a good practice and I am not surprised that the Wizard does not help.

 

[rhett7660]

Ruralguy..

I didn't even think of that.. and yup you are right.... I will make it a text field and just allow more characters.

Thanks...... Now I know for future reference.

Thanks again
R~

 

[RuralGuy]

Glad I could help.