Results 1 to 2 of 2
2001-08-01, 18:13 #1alexandreGuest
put query results into combobox (VBA/WORD2000/SR1)
I have finally gotten a SQL database connection and query right.
Now I need to get the query results to populate a ComboBox on a form.
How do I do that?
2001-08-01, 18:31 #2
- Join Date
- Sep 2003
- Thanked 0 Times in 0 Posts
Re: put query results into combobox (VBA/WORD2000/SR1)
Assuming that you are using ADO, this should do it for ya.
Replace "FieldName" with the actual name of your field; rs with the name of your recordset and cbo with the name of your ComboBox.
Do Until rs.BOF Or rs.EOF