Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    28

    Unanswered: How can I set all rowsource value to be string/Text?

    value1.RowSource = Str("select [" & search1 & "] from Input Group By [" & search1 & "]")


    it doesn't work. How can I set all rowsource value to be string/Text?

    Please help.
    Thanks.

  2. #2
    Join Date
    Nov 2003
    Posts
    1,487
    Try this:

    value1.RowSource = "SELECT [" & Me.search1 & "] FROM Input Group By [" & Me.search1 & "]"


    .
    Environment:
    Self Taught In ALL Environments.....And It Shows!


Posting Permissions

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