Results 1 to 4 of 4
  1. #1
    andvidal is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2018
    Posts
    10

    Problem with conditional.

    Hi, I need to add a conditional on the button of my form to check the value of a table.I've been trying to do it with macros, but I get the following error: the object does not contain the automation object
    Excuse me for my English level, it's not my native language.


    Thank you very much

  2. #2
    Gicu's Avatar
    Gicu is offline VIP
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    use dlookup:

    if dlookup ("YourField","YourTable","[TablePrimaryKeyField] = " & Me.UniqueID) then

    https://www.techonthenet.com/access/...in/dlookup.php
    Cheers,
    Vlad

  3. #3
    andvidal is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Jan 2018
    Posts
    10
    It worked.

    Thanks

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Great news! Good luck with your project!
    Vlad

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 11-12-2015, 10:46 AM
  2. Dlookup with conditional problem
    By Hasher in forum Access
    Replies: 5
    Last Post: 08-04-2014, 06:10 AM
  3. Conditional Formatting Problem
    By baileysw in forum Access
    Replies: 2
    Last Post: 11-21-2012, 06:23 PM
  4. Conditional Formatting Problem
    By DanKoz in forum Access
    Replies: 6
    Last Post: 10-23-2011, 12:57 AM
  5. conditional format problem in access
    By bold01 in forum Access
    Replies: 2
    Last Post: 02-10-2011, 11:35 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
  •  
Other Forums: Microsoft Office Forums