I have a Navigation Form in Access which has a dropdown, from which the user will select a Site.
Once this is chosen, a subform within the Navigation Form needs to use the value from the dropdown as a filter. But I don;t know how to do this in VBA.
The example Ihave attached has a main form within the Navigation Form. Normally thiswill hold another subform.