vba - access2010 form with a non selectable combo box -


i have access 2010 form combo box. when run ado query drop down list shows when try , select nothing selected , message @ bottom of screen says form 'readonly'.

i think problem using same recordset form , combo box.

you can use sql statement populate combo box using row source property , set bound column 1.

cboassociate.rowsource =  "select distinct assignedto pc3claims assignedto not null order assignedto"  cboassociate.boundcolumn = 1 

this populate combo assignedto values , can set control source assignedto field in form's recordset.


Comments

Popular posts from this blog

symfony - InvalidConfigurationException in SecurityExtension.php line 429: No authentication listener registered for firewall "secured_area" -

angular ui router - 10 digest iterations reached in angularjs when using $state.go -

javascript - Can Piwik report referrer in real time? -