I have some comboboxes on a form and I'd like each box's RowSource to refer to the tag I set. The tag will filter the appropriate dropdown options from a table.
SELECT DropdownNames
FROM Table
WHERE DropdownCategory=[Screen].[ActiveForm]![Me].[Tag]
What is the correct syntax? Is using the tag the best way to do this or is there a better property for this purpose?