Results 1 to 4 of 4

Thread: [Resolved}how to get combo box value into sql statement?

Threaded View

  1. Jun 22nd, 2006, 08:16 AM #1
    waely
    waely is offline

    Thread Starter
    Addicted Member
    Join Date
    Nov 2002
    Posts
    150

    [Resolved}how to get combo box value into sql statement?

    hi,
    I have a sql statement that get's data based on a combo box value and I can't seem to cencatentate it properly. that's what I'm trying to do:

    rs.Open "SELECT * FROM tblEmployees Where Proj = sheet1.combo1.value ", CNN, adOpenDynamic, adLockOptimistic

    I want to populate one combo box based on the selection of the previous combo box.

    any help is appreciated.
    waely
    Last edited by waely; Jun 22nd, 2006 at 09:46 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width