combo box in unbound subform

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
 
R

riyaz.mansoor

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
 
Top