Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    Columbia, SC
    Posts
    6

    Arrow Unanswered: Search using a form.field value

    How do I create an SQL statement that can be called by VB so I may get a value from a form.field and pass it to the SQL statement as follows.

    SELECT <tablename>.<fieldname>
    FROM <tablename>
    WHERE <tablename>.<fieldname>.value = Form_<formname>.<fieldname>.Value

    If the value exist load the record to the form.

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Try this instead:

    WHERE <tablename>.<fieldname>.value = forms!<formname>.<fieldname
    Inspiration Through Fermentation

  3. #3
    Join Date
    Aug 2003
    Location
    Columbia, SC
    Posts
    6
    Originally posted by RedNeckGeek
    Try this instead:

    WHERE <tablename>.<fieldname>.value = forms!<formname>.<fieldname
    Thanks!

Posting Permissions

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