Linking forms with "select"?



Greetings. I have linked my 2 forms with "Select" code before, here is what I
have:
Select Case source_id
Case 5
DoCmd.OpenForm "CommentCard", WhereCondition:="comment_id=" & Me.comment_id
Case Else
DoCmd.OpenForm "PhoneComments", WhereCondition:="comment_id=" & Me.comment_id
End Select

---
Now I need to specify the path for source_id somehow to the table where the
comment is stored, because I am missing source_id on the current form and
can't do anything about it. I am relatively new, so if you could help me out
that would be great
Thanks


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/200508/1
.



Relevant Pages

  • Re: Star benchmark doesnt run
    ... Duh, ... Somehow a closing paren went missing. ... Prev by Date: ...
    (comp.cad.solidworks)
  • Re: Very serios perl problem? (BUG?)
    ... > Paul Lalli: ... >> There is no way to specify pass by value. ... I must be missing the point. ... Prev by Date: ...
    (comp.lang.perl.misc)
  • Re: sphack
    ... >> The \vrule is not missing, but both lines have height zero, thus ... >> or specify the height of the \vrule. ... Prev by Date: ...
    (comp.text.tex)
  • beamer & global text color
    ... Is there a simple way in Beamer to specify a particular color ... Am I missing something in the manual, or is it necessary to specify ... Prev by Date: ...
    (comp.text.tex)
  • Re: sphack
    ... > The \vrule is not missing, but both lines have height zero, thus ... > or specify the height of the \vrule. ... Prev by Date: ...
    (comp.text.tex)

Loading