none
Query pull date from form RRS feed

  • Question

  • I have a query looking at a date on a form to pull data but the query still asks for the date although the form is open and date is entered. [forms].[billing].[month]
    Thursday, February 16, 2017 5:14 PM

All replies

  • Hi,

    First off, "Month" is a *reserved* word in Access. Second, the name of the control seems to imply a value for a month is entered. Is the user actually entering the full date value? Third, if so, then you might try converting the value into a true date using the CDate() function. For example:

    CDate(Forms!Billing.[Month])

    Hope it helps...

    Thursday, February 16, 2017 5:21 PM
  • You will probably need to post your code or indicate where the query is running from so we can take a look. Apparently the query (is it running from the Form?) is unable to resolve or identify the date argument you are specifying.

    Paul ~~~~ Microsoft MVP (Visual Basic)

    Thursday, February 16, 2017 6:30 PM