recordset of Combobox

G

Guest

40 days in now, MS, after a 10 year layoff, ya'll been brilliant.
Check this out, please sirs, (and/or ma'ams if there are):

Runtime Error '2465'
Project Mobile (3.1) can't find the field 'Controls' referred to in your
expression

what I got in mind is synchro-to-a-CBO-in-a-subform, so, (and I haven't yet a real grip on handle ref/deref statutes, (excuse me)), so I said:

Dim rs As Object
Dim ctlCBO As Object

Set rs = Forms!frmTransX.fsubTransXDetail.Form!Controls.cboAccountID.Recordset
(and alot of other combinations)

n.g.; they're sposed to be a recordset on comboboxes
 
D

Douglas J. Steele

Try either

Set rs = Forms!frmTransX.fsubTransXDetail.Form!cboAccountID.Recordset

or

Set rs =
Forms!frmTransX.fsubTransXDetail.Form!Controls("cboAccountID").Recordset


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Jim Shores said:
40 days in now, MS, after a 10 year layoff, ya'll been brilliant.
Check this out, please sirs, (and/or ma'ams if there are):

Runtime Error '2465'
Project Mobile (3.1) can't find the field 'Controls' referred to in your
expression

what I got in mind is synchro-to-a-CBO-in-a-subform, so, (and I haven't
Click to expand...
yet a real grip on handle ref/deref statutes, (excuse me)), so I said:
 
Top