Filter on an open form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank Situmorang - 17 Jul 2007 07:52 GMT

I used a command button to open a Form intended for browsing the invoice
status as follows:
Main form:
Supplier Name: ABCD
Contact persons: PQRS
subform:
Inv. No. Amount Balance Paid OUtstanding Pay. Ref
xxx xxxx xxxxxx xxx xxxx xxxxx

In the main form (continuous form) I want to create 3 command buttons for
filtering in the subform
1, OUtstanding Only
2. Paid
3. show All

Please help me how can I make it, just hitting the command button in the
main form, it will automatically works in the subform.
FYI, filter by form does work in the main form to filter only a supplier

Thanks in advance,

Frank

Reply to this Message

scubadiver - 17 Jul 2007 13:34 GMT

In the northwind database there is a form for customer contact information
that uses toggle buttons. That may help.

> I used a command button to open a Form intended for browsing the invoice
> status as follows:
[quoted text clipped - 18 lines]
>
> Frank

Reply to this Message

Frank Situmorang - 19 Jul 2007 05:38 GMT

Hi Scubadiver,

Yes, the sample similar to what I need in the form, but I can not understand
yet, how the option value relates to the company name field. My target is to
know only 3 options/toggle which formula is:
1. For outstanding only, InvBalance <>0
2. The settled one is , InvBalance=0
3. To show all is, InvBalance = All, anyway I do not know yet what should I
put here.

Thanks in advance.

Frank

> In the northwind database there is a form for customer contact information
> that uses toggle buttons. That may help.
[quoted text clipped - 21 lines]
> >
> > Frank

Reply to this Message