One Query 2 Forms

[cocoonfx]

Hello

I need some assistance. I have built a query which i have built two forms which are slightly different.

Is there a way to make each form only filter on the data entered in by that form i.e

Form 1 entered ABCD
Form 2 entered DCAB

When open form 2 i only want to see DCAB?

Is this possible???

 

[KjWhal]

Hello

I need some assistance. I have built a query which i have built two forms which are slightly different.

Is there a way to make each form only filter on the data entered in by that form i.e

Form 1 entered ABCD
Form 2 entered DCAB

When open form 2 i only want to see DCAB?

Is this possible???

As long as you plan on getting the exact same data returned you could put

Forms![form1 name]control name.Value OR Forms![form2 name]control name.Value

I think.

 

[Bat17]

you would need to a a field to the table to show which form the data had come from and use that to filter the data in the query

HTH

Peter