Parameter Query And Double click

  • Thread starter Thread starter Del
  • Start date Start date
D

Del

I have a Access 2003 database that shows our shipping information. I
have an order status form that is driven by a parameter query. The user
is asked to input the Order number. On this form there is a continuous
subform that shows a list of other order numbers that were shipped with
the one being displayed. I am looking for a way that the user can
double click on one of the other order numbers and display that order's
data on the screen.

Thanks for any input!!!
 
Presumably you already have a form for displaying order detail. Simply
create the DoubleClick event for the OrderNumber control on the subform and
insert this code:

DoCmd.OpenForm "frmOrderDetail", , , "OrderNum=" & Me.OrderNum

I usually put a button next to the control that does the same thing as a
visual cue that this functionality exists.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing a parameter from a subform to a new form? 3
filter query on combo box in a continuous subform 0
Click a subform field to open relevant form 5
Main Form and two Subforms 2
Parameter Query 9
Form Problem 1
Automatically create a record in a subform 1
filtering query 3

Back
Top