Hello!
So i have a cascading combo box with 3 choices, Site, Location and Station, this is for an inventory db.
Equipment ALWAYS is attached to a Site, sometimes to a station and occasionally to a Location. The subform is based off of the Station combo box using a macro (better to use vba?). However, if a user chooses a Site that has no Station or Location attached to it, how do I tell the macro to update the subform?! Does this make sense? Could I do an afterupdate and run some sql that will lookup the row associated with the Site and see that there is no LocationID or StationID and then run something to update the subform?
Seems a little cumbersome but instead of the cascading combo boxes i guess I could make Site a subform, Location a sub-subform and Station a sub-sub-subform with their own combo boxes...
Hopefully this isn't too ambiguous. Thanks.