Form based on LookUp Field

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • enjay
    New Member
    • Oct 2011
    • 1

    #1

    Form based on LookUp Field

    I have a two table relationship, with a Lookup Field (Transaction Type) pulling choices from the "child table." I want to create a form for each choice in the Lookup field (there are really only 2), such that user can use the form without selecting the pertinent Transaction Type.

    Is this possible? USing Access 2010.
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32669

    #2
    I can't see how this question makes sense. Am I missing something or could you express the situation more clearly such that it doesn't contradict itself.

    Comment

    • Rabbit
      Recognized Expert MVP
      • Jan 2007
      • 12517

      #3
      It sounds like they want to default the transaction type so that the user doesn't have to type it in each time.

      Just use code to set the default value. There's no need to create two different forms.

      Comment

      • NeoPa
        Recognized Expert Moderator MVP
        • Oct 2006
        • 32669

        #4
        You might be right. I can't imagine why anyone would express that idea in those words, but it's the closest thing to sense I can see in there.

        Comment

        Working...