Hi,
This is all in a web database and has to work on share point
I have a form with a combo box that has a row source of a query of Program names
I have a sub form based on a query delegates that are assigned to different programs
I want to be able to pick a Program name from the combo box and then filter the sub form for delegates assigned to that program, eventually I want to filter that list again by the location of the delegate but first things first any ideas on how I can get this to work Ive tried set filter but seem to have constant problems with it not working and throwing up errors.
Many thanks
Phill
This is all in a web database and has to work on share point
I have a form with a combo box that has a row source of a query of Program names
I have a sub form based on a query delegates that are assigned to different programs
I want to be able to pick a Program name from the combo box and then filter the sub form for delegates assigned to that program, eventually I want to filter that list again by the location of the delegate but first things first any ideas on how I can get this to work Ive tried set filter but seem to have constant problems with it not working and throwing up errors.
Many thanks
Phill
