F
Frank Situmorang
Hello experts:
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,
Frank
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,
Frank