Discussion Locked

DBCombo or DBlist Property

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do set 1)datasource 2)datafield 3) rowsource properties of DBcombo box or Dblist at runtime. I am using recordset object.
Thanks for any help.

1 reply

by sankulpune

Hello vperugu,

Assuming that you have a comb obox, with 'Combo1' as its name, on a form 'Frm1', you can any property of the combo box by using expression:

Me.Controls("Combo1"). = . (in a sub in the form code)
Or
Forms("Frm1").Controls("Combo1"). = .
(outside the form code).

The form must be open before any of the above statement is excuted.

SanganakSakha,
Simple And Effective Solutions To Small Problems, No QuickFixes.

This discussion is closed to new replies.