Mile-O Back once again... Local time Today, 13:27 Joined Dec 10, 2002 Messages 11,316 Apr 2, 2003 #21 It works the same way.
C Celtic Queen Registered User. Local time Today, 13:27 Joined Feb 26, 2003 Messages 29 Apr 2, 2003 #22 U're syntax didnt work Any other ideas? (like writing 'sub' or something?)
J jennyc Registered User. Local time Today, 05:27 Joined Apr 2, 2003 Messages 10 Apr 2, 2003 #23 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.
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 Back once again... Local time Today, 13:27 Joined Dec 10, 2002 Messages 11,316 Apr 3, 2003 #24 Change your query criteria to: [Forms]![MembersForm]![Child96]![Item1CTRLNo]