right SQL statament

[rwalle]

Hi:
I have a form that has a subform which display data for a totalize query, in the main form I filter the data displayed by the subform, so far its fine , now I'd like to open the form where the totalize line is based , I wrote a macro that on click over the totalized line opens that form but I cant figure out how the WHERE condition be constructed , I used [Forms]![SubformName]![SubformFieldName], but it doesn't work, then I changed for [Forms]![FormName]![SubformFieldName] but still no working

could somebody help me please

Thanks

Raymundo Walle

[bard777]

@rwalle
Not sure if I totally understand what you are doing, but perhaps this would work:

In your onclick event (Code Builder) -

DoCmd.OpenForm "totalize_form_name", acNormal, , , acFormEdit, , Me.SubformFieldName

[bard777]

@bard777
Sorry, I forgot to say that in your form "totalize_form_name" you will need to have a textbox to hold the openargs value you are passing it (the textbox can be not visable if you want).

Let's say the textbox is txt_OAV. In the OnLoad event for the form "totalize_form_name" enter the code below:

Me.txt_OAV = Me.OpenArgs

Then in the query to gather all your totalized data you can use

WHERE [totalize_ID] = [Forms]![totalize_form_name]![txt_OAV]

[rwalle]

Bard:

Thanks for your replay :

actually my doubt was about build the rigth where SQL in order to open the detailed form where the totalized subform is based , browsing the answers I found
http://bytes.com/topic/access/insigh...items-sub-form
and it worked for me

Thanks and Best Regards

Raymundo Walle