Hi!
My app has an unbound Main form. On it is a continuous form fProducts, and an unbound control txtCurrProd (in subform container sfProducts). The value of txtCurrProduct is set equal to Product Code of active row in fProducts by Current event of fProduct.
On main form is also a subform sfProdComponents with fProdComponents as source, which is linked with unbound control txtCurrProduct on Main form (Link Master Fields = "txtCurrProd", Link Child Fields = "ProdArtNo". This subform displays a list of components for active product in Products form.
In header of fProdComponents I have an unbound text box with formula to display a text, depending on active product on Products form, and on existence of componets for this product. I got the formula working when product has components, but all variants I tried so long either return nothing when the product has no components, or causes the text box to return an error.
The example of formula which I tried as last and which works when there are components
Code:
=IIf(Nz(Forms!fMain!txtCurrProd;"")="";"No components registered";"Components of product " & Nz([txtProdArtNo];""))
Has someone an idea how to make it to work?
Thanks in advance!