User Profile

Collapse

Profile Sidebar

Collapse
Celanese
Celanese
Last Activity: Dec 6 '09, 12:48 AM
Joined: Dec 2 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Celanese
    started a topic Where Condition help!
    in Access

    Where Condition help!

    Is there anyway to open a form and have the WHERE condition change based on which subform the user was on? I currently do this with 3 different codes, and 3 different buttons, but i'd like to just have one. The only thing that's changing in the WHERE condition is the subform name.

    Private Sub cmdEdit_Click()

    DoCmd.OpenForm "frmEdit", acNormal, "", "[Task_ID]=[Forms]![frmTask_List]!...
    See more | Go to post
    • Celanese
      replied to How to Programmatically Create a Hyperlink on a Form
      in Access
      How to Programmaticall y Create a Hyperlink on a Form - Help

      When I ran the code I got an error on:
      - Line #11 - With Application.Fil eDialog(msoFile DialogFilePicke r).

      It was a:
      - Run-Time error '-2147467259 (80004005)':
      - Method 'FileDialog' of object'_Applica tion' failed
      See more | Go to post

        Leave a comment:

      No activity results to display
      Show More
      Working...