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
 
Ad

Advertisements

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
yet a real grip on handle ref/deref statutes, (excuse me)), so I said:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recordsets 5
In(Recordset) 5
Combobox 2
ComboBox 2
Recordset question 1
Recordset Object 4
Refresh recordset 1
combobox filter 7

Top