Can I use a combo box, on a datasheet view

[liamfitz]

I'd like to use a combo box on a datasheet view subform. it's not working as I hoped. I'd like to set the control source property, to a field in the subform's recordset ( displaying like a text box ), but also use it as a combo to change/add new records. Any tips ?

 

[ypma]

I use a combo box for datasheet view in my db, using ac 2003 . I will attach an example of how it works hope this is what you required.

 

[liamfitz]

Thank you. It appears to be working now. It did seem to be adding the selection to the next ( last record )simultaneously as well, but that's fine now.

 

[liamfitz]

Thanks pat. I take your point. I probably didn't explain it properly. I only need teh combo to show/change a particular field ( of set values, entirely based on a single table ) which forms part of the recordset, which displays in my subform. It's now working as it should. Thank you.