I am working with an Access 2003 db. The a major form is a subform that has a continuous subrorm in it. The main form is for a meeting, the first form chooses from a list of goals for that participants and the continuous form allows them to choose one or more objectives for that goal that were worked on.
I need the second form to requery for the current goals for that client. It is done with a criteria in the lookup query that filters for the name of the client in the first form. This usually works.
The third form then needs to requery for the objectives that go with that particular goal. It is set up the same way with a criteria that looks for that particular goal to filter for. This one is working very sporatically.
My user base has a very low skill level so this is freaking them out. Help would be greatly appreciated.