Mark Pirks

This is a question to do with how the operating order of access works. I have a subform which is based on a query which is based on another query which is based on a date from the main form (the subform outputs into the main form as well)

When all the queries an forms are open it works fine but if only the main form is open it doesn't - it asks me to specify a value generated in the first query.

I'm wondering whether access can only handle one step at a time does anyone know if this is just the way access works or should it be working?

chiark

It works in the way it has to work: if you create something like this, you're forcing an execution order on it that won't work...

I think you might have to re-think the way that you're doing this to make it simpler, or at least block the forms until they are in a state that it is possible for them to populate with data.

ChrisB

Yup, sounds as planned to me too.

It's like you're trying to build a house but without the foundations, so Access is prompting you for the information it needs to run the query.