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.
 
Back
Top