Parametre query

[Mile-O]

It works the same way.

 

[Celtic Queen]

U're syntax didnt work
Any other ideas? (like writing 'sub' or something?)

 

[jennyc]

you can't open a form with a query - you'll need to do it using a macro. Macro's are very easy. The macro could run the query then open the form. You can put a button somewhere (a switchboard or another form) which runs the macro.

 

[Mile-O]

Change your query criteria to:

[Forms]![MembersForm]![Child96]![Item1CTRLNo]