Results 1 to 2 of 2
  1. #1
    BLD21 is offline Advanced Beginner
    Windows 2K Access 2007
    Join Date
    Apr 2011
    Posts
    55

    Crosstab Query Parameter

    access 2007,

    I have a crosstab query that contains a field called AccountName in one of my row headings.

    I have a form with a list box containing all of the account names. What I would like to do is select an accountname from the list box then have the crosstab query use that accountname selection when it runs.



    I was using something like [FORMS]![frm_Main]![Acct List] for the criteria but the error I am getting is "...the database engine does not recognize [FORMS]![frm_Main]![Acct List] as a field name or expression.

    Any ideas?
    Thanks - Bruce D.

  2. #2
    BLD21 is offline Advanced Beginner
    Windows 2K Access 2007
    Join Date
    Apr 2011
    Posts
    55
    I think I've got it now. Thanks.

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

Similar Threads

  1. Crosstab Query Bug
    By goodguy in forum Queries
    Replies: 19
    Last Post: 02-03-2011, 01:41 PM
  2. Crosstab Query Help
    By ksmith in forum Programming
    Replies: 7
    Last Post: 12-01-2010, 07:00 AM
  3. Crosstab Query
    By lukewarmbeer in forum Access
    Replies: 2
    Last Post: 08-13-2010, 05:10 AM
  4. Replies: 1
    Last Post: 07-30-2010, 10:28 AM
  5. Parameter in Crosstab Query
    By RandyG in forum Queries
    Replies: 4
    Last Post: 09-30-2009, 06:40 AM

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