Solved Problems with navigation form

[Superpat]

Hello,
I have a form that works perfectly: "f Operation".
I'm trying to create a navigation form: "_f_Navigation", I can't do it.

If I remove the condition from the "r_OperationSansCumul" query, the navigation form will start, but the account choice field will no longer work.

[Forms]![f_Operation].[txt_LongCompteFK]

But the account choice field will no longer work.

Could you help me ?

If you have an another solution

 

[arnelgp]

here i added [Tempvars]![tvarLongCompteFK] and use it as Criteria to your query.
see the Open event of f_Operation subform.

 

[Superpat]

Thanks You very much to you two.
Pat Hartman, I will try later your solution.
Arnelgp, your solution is very good, just a little problem :

Compte: FindBracket([Categorie])

And I don't find any function in french about FindBracket. If was to replace :

DansChaîne(1;[Categorie];"[")

???

I resumed my old request and everything came back in order

 

[arnelgp]

i did not find it in your db.
create the function on your Module:

Public Function FindBracket(Byval p As Variant) As Variant
If IsNull(p) Then Exit Function
p = Replace$(Replace$(p, "[", ""), "]", "")
FindBracket = p
End Function

 

[Superpat]

Thanks arnelpgp, all is good.
A last thing, can you explain me :

[Tempvars]![tvarLongCompteFK]