Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    query ciriteria from form (a2003)

    When a query pulls it criteria from an unbound control on a form, does the query pull the value showing in the control (XZY, Inc.) or does it use the first field in the unbound control's row source, or something else entirely?

    esw

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: query ciriteria from form (a2003)

    If you are talking about a list box or combo box, the value used by the query is that of the bound column of the row source. Unless specified otherwise in the Bound Column property, this is the first column of the row source, even if that column has been hidden by setting its column width to 0.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •