I've attempted several different concepts to no avail...
I would like to filter MainForm by address fields criteria available on a subform located within a 'Tab' container.
I was invisioning a "Search Button" on the Main Form that opens a SearchForm based on the address fields: StreetNumber, StreetDirection,StreetName & StreetType. If a user entered data into any of the fields, an SQL string could be generated to filter by address... But I want to filter tha MainForm not the SubForm located within the Tab control!
I hope I explained this clearly...
Jim
I would like to filter MainForm by address fields criteria available on a subform located within a 'Tab' container.
I was invisioning a "Search Button" on the Main Form that opens a SearchForm based on the address fields: StreetNumber, StreetDirection,StreetName & StreetType. If a user entered data into any of the fields, an SQL string could be generated to filter by address... But I want to filter tha MainForm not the SubForm located within the Tab control!
I hope I explained this clearly...
Jim