Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Set combo rowsource on form open event (97)

    Set combo rowsource on form open event
    Unless I

  2. #2
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Set combo rowsource on form open event (97)

    What data type is code? If it's text you don't need the ampersands. If it's a number you don't need the single quotes.

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Set combo rowsource on form open event (97)

    Code is number data type, and thanks! I just solved part of the problem as I was running an old function before the new SELECT CASE statements I entered. Now I

  4. #4
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Set combo rowsource on form open event (97)

    If code is a number then your sql string should look like this:

    strSQL = "SELECT [Code],[Description] FROM Budget WHERE [Code] = 0160250 Or [Code] = 140360249;'"

Posting Permissions

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