0

I am assigning an adodb.recordset to a combo-box.recordset via

Set COMBOBOX.Recordset = adodb_rec

This raises the resize-event of my form. How can I prevent this?

It's the same issue mentioned in this post: Shaking of my access form in maximized mode when I set list.recordset from sql server

John
  • 121
  • 10
  • I have never seen Recordset property used with combobox control. Usual approach is to set RowSource with SQL statement or query reference. Did you really name combobox as COMBOBOX? – June7 Jun 01 '22 at 03:45
  • Can't get it to work with ADO. Does work with DAO. – June7 Jun 01 '22 at 04:50
  • Does this answer your question? [How to populate a ComboBox with a Recordset using VBA](https://stackoverflow.com/questions/967399/how-to-populate-a-combobox-with-a-recordset-using-vba) – June7 Jun 01 '22 at 04:50
  • My question is not how to add data to a combobox, my question is, why does Access 2016 is flickering while adding a recordset. My question is related to this topic: https://stackoverflow.com/questions/58155795/shaking-of-my-access-form-in-maximized-mode-when-i-set-list-recordset-from-sql-s – John Jun 01 '22 at 09:56
  • Don't know what you mean by 'resize-event'. I did not observe any shaking/flicker in my test. – June7 Jun 01 '22 at 10:25

0 Answers0