Enter Parameter value

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • irslan rafique
    New Member
    • Oct 2014
    • 40

    Enter Parameter value

    Hi,
    I am trying to create a report, filtered on a combo box(txtname).
    This combo box is having a list of names.
    I have one query(mainquery ) based on a single table(maintbl).
    I created a blank form(GenerateRe port) with abovementioned combo box(txtname) and a simple button, which will open a simple report.
    In mainquery, under names column i am defining the criteria:

    [Forms]![GenerateReport]![txtname]

    Result:
    Report is being filtered accurately.
    But when I open query i receive error 'Enter parameter Value'

    The screenshot of error is being attached here.

    Early guidance will be highly appreciated.

    Thanks
    Attached Files
  • anvidc
    New Member
    • Sep 2007
    • 28

    #2
    The related form need to be open first in order the query to get the value from the form

    Comment

    Working...