I have a query opening based on the results of three cascading combo boxes. When the user see the results,they want to double click and open a form for that record. Is this possible
Novice
Windows 7 32bit 
Access 2007
I have a query opening based on the results of three cascading combo boxes. When the user see the results,they want to double click and open a form for that record. Is this possible
Who is John Galt?
Windows XP Access 2007
From a query directly? No, which is part of why most of us never let users into tables or queries directly. Base a form or subform on that query and you can do this:
BaldyWeb wherecondition
Access Developer
Windows XP Access 2003
I don't think so. I would suggest that instead of opening a query, open a form (in datasheet or continuous view) that is bound to the query. Then, you could open another form with a double click.
If this helped, please click the star at the bottom left of this posting and add to my reputation. Many thanks.
Bob Fitzpatrick
On Double Click Open Form with two criteria
double click to a record and open a new form
Posting Permissions
Reply With Quote