Unanswered: comman button won't work on subform but will on form!
I have a command button on a form which runs a macro and opens a report. The report is filtered to only display the record on the form.
So I have the following written:
However, when I put ones of these forms into a main switchboard form, so it is now subform, the report button no longer works? I can't see why! I've tried all different ways and usually end up with a report that has no records in it, or it contains all the records from the underlying table.
Please can someone point me in the right direction!!