using Control to populate combobox

I

Ingo Hanke

Dear,

I have a form where i have to populate diferent comboboxes at diferent
stages with data from a seperate database.
Im trying to write a Function that would easally repeate the task, the
main problem is specifeing what combobox to use. here is a part of my
coding


Public Sub LoadCB(cbName As Control, SelectionString As String)
cbCount = 0
Set rstLoadCB = VMSDatabase.OpenRecordset(SelectionString)
With rstLoadCB

.MoveLast
cbCount = .Counter
.MoveFirst
If TypeName(CB) = cbName Then

End If

Next CB


End With
Set rstLoadCB = Nothing
End Sub
 

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

using Control to populate combobox 1
Getting input from combobox to update sheet 8
how to populate textbox based on combobox in word from excel 0
How to select cells with checkboxes? 1
Combobox 1
Unable to display values in ComboBox using SQL query from table 2
ComboBox Problem with ListIndex 2
Can't select option in combobox 0

Top