Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    62

    Unanswered: comman button won't work on subform but will on form!

    Hi all,
    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:
    [Fieldname]=[Forms]![Formname]![Fieldname].

    This works.


    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!!
    thanks
    Sue

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •