Can we filter data in 2 steps?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello experts:

I have 2 forms: Main form for suppliers name and address, and subform for
invoices details Supplier and Invoices table is linked with Suplier No.

My question is, After we filter by supplier showing the invoice detail, can
we then filter the subform to show the following items:
1. Unpaid invoice only
2. Paid Invoice Only
3. Show All

I have tried to put an option group toggle button on the header of subform
similar to the Customer Phonelist Form, but it does not work.

Thanks in advance for anyidea provided.

Frank
 
Frank, I would put a tab control on the main form with 4 tabs. Put your
current subform on one tab and 3 new subforms on the other tabs.
UpRider
 
Thank you UpRider for your quick response, however I want to know more about
putting it on 4 tabs, maybe any to add more explanantion in order to know my
problems:

I have mainform contains Supplier details and I have subform contains
invoice details linked table with supplier number so we can see all invoices
per supplier. My combo box to filter supllier can work perfectly now and it
shows all invoice details.

Now my 2nd step, is to filter only to:
1. show up the outstading only
2. The paid ones
3. Show all
For this purpose I created on the subform header a option group button using
macro like the Customer Option group of Northwinds sample data base which is
using macro attached to the form more or less as follows:
BrowsingSupplierSubform.SelectRecrd
Macro name Condition Action Comment
Attched to the AfterUpadate of Option Group
SelectRecrd SelectRecordFilter apply Filter To show the Outstanding
SelecgRecordFilter Apply Filter To show the paid ones
SelectRecord Filtrer Apply Filter Show All Records

I PUT ON THE MAIN FORM EVENT: ON APPLY FILTER, THE MACRO BUT IT DOES NOT
WORK, THE ERROR MESSAGE SAYS: The object does not contain the Automatation
Object "SelectRecordsFilter". You tried to run a Visual Basic procedure to
set a property or method for an object. However, the component does't make
the proerty or method available for Automation operations.

Check the component's documentation for information on the properties and
methods it makes available for Automation operations.

For your information, my macro for the above 3 button are working if we run
it on the subform alone, but when we run it on the mainformwith the subform,
THE ABOVE ERROR MESSAGE OCCURED.

Thanks in advance for your kind help

Frank
 
Frank, I VERY seldom use macros and am in no way a resource for that kind of
advice. Maybe someone else with knowledge and interest in macros could help.

UpRider
 
Back
Top