Button to launch a form from a report

dimanche 1 mars 2015

I have a fairly simple report which lists rows from one table with a little bit of logic. At the end of each row, I want an action button, which when you click it, goes to a form with the correct ItemID for that row.



I tried the VBA code like this on the View button on click method:



DoCmd.OpenForm "CreateCAF", , , "[ItemID] = " & Me.ItemID



Of course, what happens is it opens the form CreateCAF with the first ItemID in the report, regardless of which row you click on. I want it to pick up the ItemId of that row.



How do I do this please? :)



thanks

James

Button to launch a form from a report

0 commentaires:

Enregistrer un commentaire

Labels