Question How to add Combo box field to Data Sheet view in form

[pcride]

Hi, I have no where to turn to except the best place I know where to get the answer

I created a new field as a text box, converted it to Combo box, then the Values are pulled from a query and all that works fine.

I have a form that opens and displays these Fields in a Data Sheet view and the new Combo box doesn't drop down and is flagged as a text box in the property bar but no way to change it??

I need the drop down like the other Category field I have, that works but this one doesn't.

See screen shot.

You can see in the Category field, there is a Drop down, but in Category II there is not, even though this is a drop down field. - BUT in this data sheet view it doesn't show it as a drop down.


http://tinyurl.com/qaaz5o9

 

[pcride]

In the main Table design view, in the Look Up Tab under field properties, there is a setting for Text, Combo, List etc...

But that didn't fix it.

 

[pcride]

I might add my Form is configured for SPLIT VIEW, so I can't get the DROP DOWN TO ACTED AS A DROP Down COMBO BOX IN SPLIT VIEW under Form.

I hope this makes sense and someone can help.

 

[pcride]

I think I am close to figure this out.

I deleted the column and re-added using Combo box. Now I have the drop down choices. However when I make a choice in the Combo box, it changes all of them for all records to the same. How do I fix this?

 

[pcride]

Ok its all resolved now. It was a problem with the Binding Column. Access makes it difficult.

 

[essaytee]

It's a pity you can't thank yourself for answering your own question. I like your style though, you got there.