Hi all, I have a quick question, I'm going to make this sound more complicated than it is I think - I have a subform that, with the extremely kind help of members of this forum, I have managed to filter to show 'pending' invoices from my table.
What I want to do is have a 'navigation form' that has my current form and sub-form (with pending invoices) on one tab, then 'complete' invoices on another tab. What I can't do, is set the second tab so it shows only 'complete' invoices that relates to the record on the first tab. At the moment, it just shows all the complete invoices. I think it has something to do with something called 'master link field'.
Fundamentally, what I want to do is have a navigation form with a second tab that contains a subform, rather than a form.
Could somebody help me please?
What I want to do is have a 'navigation form' that has my current form and sub-form (with pending invoices) on one tab, then 'complete' invoices on another tab. What I can't do, is set the second tab so it shows only 'complete' invoices that relates to the record on the first tab. At the moment, it just shows all the complete invoices. I think it has something to do with something called 'master link field'.
Fundamentally, what I want to do is have a navigation form with a second tab that contains a subform, rather than a form.
Could somebody help me please?