I'm working on an invoice system for a company and they reqiure notification when an account is called up on a form that has an outstanding invoice.
So I created a query that locates all unpaid invoices, I made a form using that query, and I want to use it as a subform on my main invoice page.
But I'd like this subform to only popup when the criteria is met, that is the name on the subform matches the name on the current invoice called up.
Right now the subform is blank when the criteria is not met, and fields are filled out when they are...but I'd rather a nice big popup that can really get their attention...any idea if this is possible on Access 2000?
Thanks!
So I created a query that locates all unpaid invoices, I made a form using that query, and I want to use it as a subform on my main invoice page.
But I'd like this subform to only popup when the criteria is met, that is the name on the subform matches the name on the current invoice called up.
Right now the subform is blank when the criteria is not met, and fields are filled out when they are...but I'd rather a nice big popup that can really get their attention...any idea if this is possible on Access 2000?
Thanks!