forms - Access VBA Run Time Error 2465: Application-defined or object-defined error -
i have form named ui(navigation form) in ms access 2010. have 2 more subforms search , results tabbed forms in ui. after search in search form, when click results tab want value combo box named 'cmbid' in search displayed in label named 'lblaipiddisp' in results form , display additional labels. so, gave following code in navigation button click event:
private sub navigationbutton32_click() form_results.lblaipiddisp.caption = [forms]![ui]![search].cmbid.value end sub
but run time error 2465. so, tried searching in search form separately , gave following code in form load event of results form:
private sub form_load() form_results.lblaipiddisp.caption = [forms]![search].cmbid.value end sub
now, searched in search form , clicked on results form. able see value in combo box 'cmbid' in search form in label 'lblaipiddisp' in results form. so, think there wrong in referencing subforms results , search in navigation form ui. needed in point.
Comments
Post a Comment