Hi
I can usually get by and work things out for myself after searching through this forum but I'm struggling with this one.
I'm used to launching a sub-report from a fields event button on a report to launch another report filtered by the current record value
DoCmd.OpenReport "kit master", acViewReport, , " project='" & Me!Project & "'" would be typical....
I have a simple update query I want to run from an event button at record level on my report
DoCmd.OpenQuery "copy of pkg" where I want to update only the record where the ID autonumber matches the current ID Autonumber record on the report
I cant get this to work and would be grateful to anybody who can point me in the right direction with the code/syntax to do this
Thanks
Ian