applyfilter in subform

A

alecarnero

i have a form with a textbox named NOTAFISCAL and a a subform, with
details of the sales , is posible apply a filter in the subform , i want
only view only the rows related with the value NOTAFSICAL, how i can do
this, i have try with the filter propierty but any results, i have another
ideia please tell me , thanks

Alejandro Carnero
Santos-BRAZIL
 
J

Jeff C

alecarnero said:
i have a form with a textbox named NOTAFISCAL and a a subform, with
details of the sales , is posible apply a filter in the subform , i want
only view only the rows related with the value NOTAFSICAL, how i can do
this, i have try with the filter propierty but any results, i have another
ideia please tell me , thanks

Alejandro Carnero
Santos-BRAZIL
Click to expand...

Alejanddro

Vai para Exibir Modo Design
Clicar no subformulário controle e achar a janela de propriedades.
Vai para tab 'Dados'
Vinicular campos filho digite NOTAFISCAL
Vinciular campos mestre digite NOTAFISCAL

Agora, o subformulário será ligado ao forumulário principal e mostrará
os dados no subformulário quando igual ao valor no NOTAFISCAL do
formulário principal.

Campo filho é o campo no subformulário que tem o valor igual à caixa de
texto no formulário principal
Campo Mestre é a caixa de texto NOTAFISCAL no formulário principal

Espero que ajude!

Jeff C
 
A

alecarnero

Thanks JEFF i have use this with success

Me.inter.Form.FilterOn = False
Me.inter.Form.Filter = "notafiscal = '" & Me.Notafiscal & "'"
Me.inter.Form.FilterOn = True
Me.inter.Requery
 
Top