var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Run query from event
I have a form with two comboboxes. Each combobox is attached to a table for lookups. So I like to filter the contents in lookup table in combo2 dependent on the selection on the combo 1.
The table connected to combo2 has 2 columns. I only show column 1 in combo. The other has attached a label with same as table for selection on combo 1.
So I came up with this query:
This query is found under data, row source. It looks like it runs only once when I open the database form first time. I like this to run everytime I chenge a selection on combo 1.
SELECT SubSystem.SubSystem, SubSystem.MainSystem
ORDER BY SubSystem.SubSystem;
How to do this?
Place this in the After Update event of combo1
Private Sub combo1_AfterUpdate()