Subform - Enter the value of the parameter

[eugewp]

I have a query based form A , it filters by a parameter that it gets from a subform [F4_OCs] in the main form [F4_Inventario]. Until here everything works.

The problem is that when using the form A as a subform in other form (B), the popup appears.

The only way to open the form B is in the main form with a button, so the parameter is avaible.

This is the filter in the query

[Formularios]![F4_Inventario]![F4_OCs].[Formulario]![Id_OC]

 

[Minty]

If the form can be opened in either stand-alone or as a subform you will have to use code to determine where to get the source data from.
You could use an open args to set the recordsource.

Pseudo code - if you pass openargs then it's opened as a form on it own, therefore use recordsource A else it's a subform use record source B?

 

[eugewp]

If the form can be opened in either stand-alone or as a subform you will have to use code to determine where to get the source data from.
You could use an open args to set the recordsource.

Pseudo code - if you pass openargs then it's opened as a form on it own, therefore use recordsource A else it's a subform use record source B?

Thanks for your quick reply.
I don't know about open args.
But i will try to get the parameter in the form B in some hide textbox and then call it in the query.

 

[Gasman]

The references would be different re main and subform?

I would use a TempVar and set that from any form.?

 

[eugewp]

Thanks for your quick reply.
I don't know about open args.
But i will try to get the parameter in the form B in some hide textbox and then call it in the query.

its works but, some really strange happens. The form don't stop requerying.

 

[eugewp]

The references would be different re main and subform?

I would use a TempVar and set that from any form.?

The parameter is an ID.
The subform (data sheet) that i get it is in the main form.
How can i pass a TempVar to a query?

 

[Gasman]

The parameter is an ID.
The subform (data sheet) that i get it is in the main form.
How can i pass a TempVar to a query?

You refer to it in the query instead of the form control and you set it prior to calling the query.

 

[eugewp]

You refer to it in the query instead of the form control and you set it prior to calling the query.

I try it, but don't works. it's the same as the first.

 

[Gasman]

I try it, but don't works. it's the same as the first.

Not possible as long as it has a value?

 

[eugewp]

OK. It finally works... I'm sure that it isn't the rigth form to do this.
How works:
- I create a public function that gets the value of the id.
- I use it for do the query
- I put a textbox in the form with the name of que parameter of the popup and put as value the function

 

[Gasman]

If you have set the TempVar, then you can just use that on your form or wherever?

 

[eugewp]

If you have set the TempVar, then you can just use that on your form or wherever?

I don't need the ID actually. I need to complete some data in a table, for that a use a query (which is filtered by the ID). Whith this, i was create a form.