combo box in unbound subform

  • Thread starter Thread starter riyaz.mansoor
  • Start date Start date
R

riyaz.mansoor

hi

in an unbound subform, i have a combobox which is populated (in
subform.onopen) via the following statement where tCtl is the correct
combobox control.

Set tCtl.Recordset = currentData.Users.Clone
Debug.Print tCtl.Recordset.RecordCount

if the subform's view is Form, then it loads correctly => theres
nothing wrong with code.

but if the subform view is datasheet, there is nothing in the dropdown
list within the combobox. debug statement actuvally gives an error

what am i missing? i have done this before for a previous project, but
i just can't seem to get past this! :(

riyaz
 
got a solution. using access 2003, sp2

set the form recordset and then combobox recordsets to view the
combobox list data in datasheet view.

riyaz
 

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

filter query on combo box in a continuous subform 0
Unbound Combo Refresh 1
Update subform with combobox change on main form 1
Calculated Field in a Subform 10
Unbound combobox AfterUpdate 5
subform duplication records 5
Form/Subform Problem 1
combo box in subform is blank 5

Back
Top