Works with Navigation forms as Master/Child Forms

[zyltar]

Hi,



I would like to Use Navigation forms as form/subform.

I have a navigation form which is bound to a recordset and in the header I display some information about the selected client. I would like to synchonize the included "subforms" with the dataset in the header of my navigation form.

I did'nt find any built-in possibility.... will I need to filter manually every forms included in my navigation forms ? Or does it exist an easier way ?

Many thanks in advance for your help.
Regards

[zyltar]

Hi,

As I don't see any answer, I explain how I do that, and if someone has a easier way to do that, please tell me.

On the queries of the "subform" in the navigation form I put in the were clause the common id_fields.

Now with VBA I have to insert manually the foreign key in the field. Then I put a trigger on exit of one of the mandatory fields and I test if my foreign key is null, and if it is, I add the value of the id_field in the top of my navigation form.

Navigation forms are a great improvement of recent access version but the fact we cannot have open args and filter and where clause in the forms embedded in is a very important missing feature.