Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2006
    Posts
    39

    Unanswered: Please Help. IF statment condition

    Hey all,
    So here's my delima...

    I have a Yes/No field called LOA on a form.
    I need to set this up so IF it is selected, rendering the option "Yes", a specific table called "Locations" opens.

    Please....any advice would be greatly appreciated.

    Thanks,

    B

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Try:
    Code:
    If Me.LOA.Value = True Then
        Docmd.OpenTable "Locations"
    End If
    Are you sure you actually want to open a table? This is not among the recommended ways for accessing data.
    Have a nice day!

  3. #3
    Join Date
    Dec 2006
    Posts
    39

    Thanks!

    I appreciate you helping me with this.

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You're welcome!
    Have a nice day!

Posting Permissions

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