Limit List

[mcwebb]

Hello,

I have a form, where one feild is linked to a list. Currently, this is a drop-down field, and i would like to make it so that you can select something from the list, or type in new data, that would then update the list. When I try to change the "limit list" to "No" in the properties, an error message pops up about column widths. When I delete the 0, all the previous records in the database show numbers referencing the list, rather than show the text.

Is there a way to change that drop-down box, but still see the text in previous records?

thanks in advance

Edit: Ok, maybe the data needs to be linked differently? Right now, the only way I can get it to show the text is to link the data directly to the list...Sorry if this is a rookie question!

 

[rhett7660]

Yes...

Select the combo box then right click properties>>Format>>Column count = 2
>>Column Widths 0";2"

This should show the text not the number.

R~

 

[mcwebb]

Yes...

Select the combo box then right click properties>>Format>>Column count = 2
>>Column Widths 0";2"

This should show the text not the number.

R~

Still not working. doing that, it shows the numbers and you cant even select text. Any other ideas as to what is going wrong?

 

[rhett7660]

What "0" are you deleting, is it in the drop down list or is it in one of the property fields. Just want to make sure we are talking about the same thing.

Did you use the wizard to setup this button?

R~

 

[mcwebb]

What "0" are you deleting, is it in the drop down list or is it in one of the property fields. Just want to make sure we are talking about the same thing.

Did you use the wizard to setup this button?

R~

I was deleting the 0 in the properties: Format>>ColumnWidths, because I had read that it could cause problems with Limit to List. I used the wizard to set up the button, and originally was just a list box. After changing it to a combo box, i can't get it to let me type anything in (let alone see the original text on the earlier entries). It tells me that I must select from the List still.

thank you for your help, this is making me tear my hair out!

 

[rhett7660]

I have a feeling you might need to base your combo box on a query and then have that query update your table if something new is added. Does this make sense?

Sorry I don't know how else to help you... Hopefully someone with more experience jumps in..

R~