Clicking on Query Results to Open a Form 1

[VRoscioli]

Hello

I have an Access database in which I want to do the following:

There is a form showing information indexed by a parameter called WCN. I also have a query which displays a certain list of records. What I want to do is to be able to click on one of the result rows in the query to open the form and show the data with the associated WCN. Is this possible in Access?

Thanks.

 

[Crowley16]

the query results pane doesn't have any accessible code you can program, so no, you can't.

what you can do is to make your form look like the query results and then use the event handlers on the form to achieve this.

either a continuous form, or a list box...

--------------------
Procrastinate Now!

 

[VRoscioli]

Okay that's what I thought I might have to do. I was just wondering if there was a better way. Thanks for your reply.