Can I populate listbox B based on the selection of listbox A without using any VBA--using only queries/SQL? My reason for wanting to do this is that I want to have this database usable on SharePoint and I don't think SharePoint will let me run code. At least I know I can't run any Excel macros via Excel Web Access on SharePoint.
Listbox A will display unique values of Field1 from Table1. Based on the selection in Listbox A, Listbox B will display corresponding records from Table1, Field2. Then, based on a selection from Listbox B, Textboxes C, D and E will display a single item from 3 different fields from Table2. Tables 1 & 2 are related via a one (Table2) to many (Table1) relationship.
Again--can this be done without VBA code, using only queries?
My Access is quite rusty these days, so thank you in advance for any help!
Bruce