Results 1 to 5 of 5
  1. 10-20-2023, 11:13 PM #1
    TamworthBob
    TamworthBob is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    May 2020
    Posts
    7

    getting value of a field from a record found by using FindFirst

    How do I get the value of a field from a record found by using FindFirst?
    I wish to get the field value to compare it with a known value
    Thanks Bob
    Reply With Quote Reply With Quote
  2. 10-21-2023, 12:04 AM #2
    June7's Avatar
    June7
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Do you mean field of a recordset?

    Like: rs!fieldname

    Show your code.
    Last edited by June7; 10-21-2023 at 12:27 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  3. 10-21-2023, 11:53 AM #3
    CJ_London
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    Like: rs!(fieldname)
    don’t you mean

    rs!fieldname

    or

    rs(“fieldname”)
    Reply With Quote Reply With Quote
  4. 10-21-2023, 12:28 PM #4
    June7's Avatar
    June7
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Yep, edited post.

    Only not with smart quotes.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  5. 10-21-2023, 12:53 PM #5
    CJ_London
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    Only not with smart quotes.
    i’m on my phone and unfortunately they are the only quote’s available
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. The search key was not found in any record
    By virtualprg in forum Import/Export Data
    Replies: 46
    Last Post: 08-26-2014, 10:51 AM
  2. FindFirst not working when using DATE field in criteria
    By Praveenevg in forum Access
    Replies: 5
    Last Post: 08-20-2014, 10:18 PM
  3. How to Set Focus to a Record and Using FindFirst
    By BallinWallin in forum Programming
    Replies: 3
    Last Post: 07-20-2014, 08:05 AM
  4. Findfirst failing with a variable drawn from an autonumber field.
    By byterbit in forum Programming
    Replies: 1
    Last Post: 07-19-2011, 05:45 PM
  5. if record not found through combo box
    By wasim_sono in forum Forms
    Replies: 2
    Last Post: 08-04-2008, 06:32 AM

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

Other Forums: Microsoft Office Forums