Double-click on query output and open form

[klar]

Hi Access gurus,

Not sure if I should ask this question on queries or forms. I would like to implement a convenient search feature. By using queries to generate the search results, I would like to click on the row wanted and open the relevant form for that record. May I know if this can be done using queries?

I believe this is a more user-friendly way than to ask user to browse through filtered records one by one.

 

[Trevor G]

You can't do that from a query, try this, create a continuos form from the Query then go into design view select the ID field and open the properties then you can use the On Double Click Event and create a macro that will Open the form and in the arguments below set it to the Field on the form to the Field from the table that way it will open direct to the record from the other form.

 

[klar]

You can't do that from a query, try this, create a continuos form from the Query then go into design view select the ID field and open the properties then you can use the On Double Click Event and create a macro that will Open the form and in the arguments below set it to the Field on the form to the Field from the table that way it will open direct to the record from the other form.

Thanks for the reply. Is it possible to create a form that accepts parameters for the query, then use that query to create the continuous form and the do the stuff that you suggested?

 

[Trevor G]

Design the form based on the query and set a parameter so that when you open the form you fill out the parameter and it then shows you the records in question, then you can continue with the information as per my first reply.

 

[MACKTRUCK]

Hello,

I am new here, but have been searching for the answer to the same question posted and am wondering if there is a way to use VBA instead of a macro to accomplish the same result when double-clicking on the desired record.

 

[Pat Hartman]

Welcome Aboard

Use the OpenReport Method to open a report.

Put the code in the click event of a button or the double-click event of a field.

DoCmd.OpenReport "rptName", acViewPreview,,"YourID = " & Me.YourID