Results 1 to 3 of 3
  1. #1
    Joakim N is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Oct 2016
    Posts
    79

    Criterion in a Query

    I get an error message when I have written following as a criterion in a query:

    [forms]![FMenu]![cboUnit].column(0)

    I get following error message:

    Click image for larger version. 

Name:	Capture.PNG 
Views:	8 
Size:	7.5 KB 
ID:	26131


    The form FMenu with cboUnit is active and has a value. In Immidiate Window I type:



    ?[forms]![FMenu]![cboUnit].column(0)
    and get the value 2.

  2. #2
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Remove the ".Column(0)" - it will default to the first column.

  3. #3
    Joakim N is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Oct 2016
    Posts
    79
    OK. Thanks!

    Worked.

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

Similar Threads

  1. Datatype error in criterion selection
    By Mahendra1000 in forum Access
    Replies: 12
    Last Post: 07-21-2015, 05:55 AM
  2. Replies: 6
    Last Post: 06-16-2014, 04:21 PM
  3. Len expression as criterion?
    By Duradel in forum Queries
    Replies: 3
    Last Post: 01-19-2014, 01:37 PM
  4. Weird Query Results using Percentage criterion
    By david.semadeni in forum Queries
    Replies: 6
    Last Post: 04-09-2012, 10:59 AM
  5. Query criterion for today and the future
    By scoughlan in forum Queries
    Replies: 3
    Last Post: 01-16-2012, 07:28 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