Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Location
    Illinois
    Posts
    14

    Form field not displaying in query

    Hello,



    I created a form that I enter criteria for a report. The query will not display the date field, yet if allows me to use it in a IIF statement. I need to display it in the report. I have spent lots of time trying to figure out if I missed something in the creation of the form, or if I am not retrieving it in the correct manner. To retrieve it I am using FromDate: [forms]! [PymtDueRpt]![FromDate]. FromDate is the name in the form.

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    That should work.

    Check to make sure you are spelling the form name and field name correctly.

    Try it in the debug window to verify.

  3. #3
    Join Date
    Apr 2006
    Location
    Illinois
    Posts
    14
    Sorry,Don't see a debug window in the Microsoft Access 2003 query. Where will I find it?

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Displaying a picture on a form
    By kydbmaster in forum Forms
    Replies: 4
    Last Post: 04-04-2009, 07:54 PM
  2. form not displaying fields
    By ashiers in forum Forms
    Replies: 0
    Last Post: 09-19-2008, 07:02 AM
  3. Displaying Query Properties in a Form
    By Bjar in forum Programming
    Replies: 1
    Last Post: 07-16-2008, 07:51 AM
  4. Replies: 1
    Last Post: 10-26-2007, 07:29 AM
  5. Displaying a PDF in a Form
    By Chaz in forum Forms
    Replies: 0
    Last Post: 08-07-2006, 03:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums