Hello everyone,
I am trying to create a form in which the user selects a group of records with a combobox which runs a query. The result of the query looks like
Configuration ID Color
6 red
9 green
18 blue
22 cyan
On the from, I have four labels in which I'd like to show the text "red", "green", "blue" and "cyan"?
I know, that I have to work on a VBA module for the combobox after update.
However, I have no idea how to run the query when the value is selected?
How do I access the single "cells" of the query in VBA?
Thanks,
Benjamin