Problem on setting source in continuos form

[diegomarino]

hi,


i have a continuos form called "composition" with recordsource is based on this

   Me.RecordSource = "SELECT [DB 1T ptf banca taglio clienti].TrattativaID, [DB 1T ptf banca taglio clienti].CandidatoID, [DB 1T ptf banca taglio clienti].[Taglio cliente], Count([DB 1T ptf banca taglio clienti].[Taglio cliente]) AS [ConteggioDiTaglio cliente], Switch([taglio cliente]=""<100k"",1,[taglio cliente]=""100k-300k"",2,[taglio cliente]=""300k-500k"",3,[taglio cliente]=""500k-700k"",4,[taglio cliente]=""700k-1mln"",5,[taglio cliente]=""1mln-2mln"",6,[taglio cliente]=""2mln-5mln"",7,[taglio cliente]=""5mln-10mln"",8,[taglio cliente]="">=10mln"",9) AS Ordinamento " & vbCrLf & _   "FROM [DB 1T ptf banca taglio clienti] " & vbCrLf & _
   "GROUP BY [DB 1T ptf banca taglio clienti].TrattativaID, [DB 1T ptf banca taglio clienti].CandidatoID, [DB 1T ptf banca taglio clienti].[Taglio cliente], Switch([taglio cliente]=""<100k"",1,[taglio cliente]=""100k-300k"",2,[taglio cliente]=""300k-500k"",3,[taglio cliente]=""500k-700k"",4,[taglio cliente]=""700k-1mln"",5,[taglio cliente]=""1mln-2mln"",6,[taglio cliente]=""2mln-5mln"",7,[taglio cliente]=""5mln-10mln"",8,[taglio cliente]="">=10mln"",9) " & vbCrLf & _
   "HAVING ((([DB 1T ptf banca taglio clienti].TrattativaID)=[Maschere]![home].[sottomascheraspostamento2]![sottomascheraspostamento1].[form]![CCSceltaTrattativa])) " & vbCrLf & _
   "ORDER BY Switch([taglio cliente]=""<100k"",1,[taglio cliente]=""100k-300k"",2,[taglio cliente]=""300k-500k"",3,[taglio cliente]=""500k-700k"",4,[taglio cliente]=""700k-1mln"",5,[taglio cliente]=""1mln-2mln"",6,[taglio cliente]=""2mln-5mln"",7,[taglio cliente]=""5mln-10mln"",8,[taglio cliente]="">=10mln"",9);"

works fine, it is on "on load" event, so when i load my form i see data as it should

as you can see i have a criteria based on "[Maschere]![home].[sottomascheraspostamento2]![sottomascheraspostamento1].[form]![CCSceltaTrattativa]" (maschere! is forms!). the control is in multi level navigation forms.
now, i want to change this criteria in a simple " & me.openargs & ", cause i can open the main form either through the navigation form that the form directly.

so i just overwrite "[Maschere]![home].[sottomascheraspostamento2]![sottomascheraspostamento1].[form]![CCSceltaTrattativa]" and i put " & me.openargs & ", sometimes it works sometimes not

the problem specifically is when i open not the form "composition", but when i open another form that contains this "composition" form, i have an error of too much ")" in closing the criteria
i'm guessing how i have to write the criteria

[pbaldy]

Are you still using OpenArgs when the form is a subform? If so you can try

Me.Parent.OpenArgs

Or test for OpenArgs being null and using the form reference if it is.

[diegomarino]

man, it was precisely as you said. I'm just learning now and i'm being addicted to this forum

thanks very much

[pbaldy]

Happy to help!

[diegomarino]

however, is there any way to check if the form is a form or a subform in another form? sometimes i open this form as indipendent form

[pbaldy]

I'm not at a computer right now. Check out IsLoaded. You can use it with the form's name. If it doesn't show as loaded, it's a subform.

[diegomarino]

good, i've found that there is "isSubform" too

[pbaldy]

Ah, good job. I haven't needed it, good to know it exists.