Re: Load second combo box
First of all, when you post code please put it inside VBCode tags - either using the button in the post editor screen, or by putting them in manually, like this: [vbcode] 'code here [/vbcode]
Also, when some code you have written isn't working, it's best to tell us why it isn't (such as any error messages that are shown).
Anyhoo, you appear to be missing these lines:
VB Code:
Set lrs2 = New ADODB.Recordset
Set lrs2.ActiveConnection = m_con
lrs2.CursorLocation = adUseClient
lrs2.CursorType = adOpenStatic
Re: Load second combo box
Thanks, worked like a charm. I'll use the vb quotes next time as well as give the error.