Use double click event to jump to new form and filter data (Access 2003)

[keliie]

Hello,

I've created a subform that displays the results of a query. The
results of the query contain a unique ID named "Invoice_ID". I want to
be able to double click on a specific row in the subform to run a macro
which opens a new form and automatically "jumps" to the selected record
(note that the new form also contains a unique ID titled "Invoice_ID").

My preference is to accomplish this through a macro b/c I don't have
much experience with programming VB. However, at this point I am open
to anything.

Thanks :D

[Jeremy Wallace]

Do it with VBA, not macros. It's much more powerful, and if you're
going to bother to learn, you might as well learn the better tool.

Here's a very simple bit of code that will do the trick. You can put
the same code behind every control on the subform, so the user can
double click anywhere.
Private Sub txtSomeField_DblClick(Cancel As Integer)
call DoCmd.OpenForm ("frmSomeForm", , , "Invoice_ID = " &
me!txtInvoice_ID)
End Sub

A better solution, though, would be to have one function that gets
called from each of those doubleclick events. That would look very
similar:
Private Sub OpenTheInvoice
call DoCmd.OpenForm ("frmSomeForm", , , "Invoice_ID = " &
me!txtInvoice_ID)
End Sub

Then the code behind each of the doubleclick events would look like
this
Private Sub txtSomeField_DblClick(Cancel As Integer)
call OpenTheInvoice
End Sub

There are tons of other ways to go about this, which is one of the
great (and sometimes frustrating) things about programming. Welcome to
our world. It's kind of fun.

Jeremy
--
Jeremy Wallace
Fund for the City of New York
http://metrix.fcny.org

[keliie]

Jeremy,

Thanks for the nice response and I appreciate your sample code. I'll
definately use it in the database.

Best,

Kelii