Linking forms with "select"?

  • Thread starter Alex P. via AccessMonster.com
  • Start date
A

Alex P. via AccessMonster.com

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
 
Top