Is it possible - search?

[Luka]

Hi everyone,

I have this situation.

Main form
1 subform - child to mainform (fields are NOT connected with ID)
2 subform - child to 1 subform (fields are connected with ID)

Main form is used for searchig
1 first subform shows item records
2 subform shows some data connected to items

Search field on main form is where condition on query which is behind the subforms. Search on 1 st subform works fine. I type value in main form search field and get only the results whit that value. But the 2nd subform is not searched.

Is it possible to search 2 nd subform from main form?
2 nd subform is child of 1 st subform!

 

[MStef]

Hello Louka!

As I can understand you, you don't need 3 forms, it's enough 2 forms.
Send a short example of your MDB.

 

[Luka]

Thanks for your reply.

What i need to know is how to search the sub - subform (see the attachment).

Uses some slovenian language, i think you'll understand it.

 

[Oldsoftboss]

If I read correctly you want to search the OPIS field?

 

[Luka]

Actually any field (see the query behind). The idea is to search the subform and subform of subform at the same time.

 

[Oldsoftboss]

The trouble with what yo are doing, and the way you are doing it, if no criteria is met in the first subform then no records are returned.

 

[Luka]

I found a solution: I made another subform like first one, which shows the data from subsubform. This one can now be searched from the search line on main form.

Thanks for answers.