Access: Form Combo control source (change) | Access forum

Hi Joe,

Thank you for the forum question.


I have a solution for you. I created a table exactly like your table, and a query exactly as your query. In the form I added a combobox and 3 command buttons. I added a on_click event for each of the command buttons and used the code builder. In the code builder I added the code:

Private Sub Command11_Click()
Me.Combo0.RowSource = "SELECT Colours.Colours1 FROM Colours;"
Me.Requery
End Sub

Private Sub Command12_Click()
Me.Combo0.RowSource = "SELECT Colours.Colours2 FROM Colours;"
Me.Requery
End Sub

Private Sub Command13_Click()
Me.Combo0.RowSource = "SELECT Colours.Colours3 FROM Colours;"
Me.Requery
End Sub

If you copy and paste the code you will need to change the names for the command buttons and your combobox to the names for you controls.

This did the job.

I have attached my database with my solution.

I hope this will do the job for you.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Read more: https://www.stl-training.co.uk/post-34995-form-combo-control-source.html #ixzz36OCfWRAx