Jump to record

[smeco]

I have a form with a list of all payments
I'd like to make it so that, by double-clicking on the 'amount' box, I get taken to a form which prints the detail of that specific payment

I've created a macro that opens the specific form, but how do I make it jump to the record from which I double-clicked?

I hope that was clear, thanks in advance
smeco

 

[SydneyGeek]

If you want to open Form2, synchronised with the ID on Form1, here's what you do:

Design view on Form 1, drag a Command Button onto the form -- with Wizards ON. When the wizard launches, select Open Form from the options. Select Form2 when prompted. You'll also be asked if you want to display a specific record. Match up the IDs on both forms, give the button a cpation, and you're done.

If you don't want to keep the button, you can go to its code, copy the lines with stDocname and DoCmd, and paste them into the Double Click event of the Totals control.

Denis