Solved Problems with navigation form (1 Viewer)

[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

 

[Pat Hartman]

The navigation form is a red herring. I don't use it because it is easy enough to create the same thing yourself by just using the Tab control and you won't run into the gotchas.

Your problem is that once you put a form on the navigation form (whether you use the Access one or roll your own), the form becomes a subform and the reference to controls on it now requires a "higher" level reference.

Forms!yourmainORnavigationform!yoursubform.Form!txtcontrolname

Notice that the parentform.Form got inserted

An additional issue with the Access navigation form is that only ONE subform is ever loaded at one time so you can only reference the VISIBLE subform.

 

[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]