Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

still having trouble...

Discussion in 'Information Technology' started by aheath15, Jul 28, 2006.

  1. aheath15

    aheath15
    Expand Collapse
    Guest

    still stuck on the same problem:
    I have a table of products, from which a user can create an order by using a
    form, and checking off the products they want. I need to create a code that
    automatically selects another product if one specific product is selected.

    For example, say product A requires that product B be selected. So, when a
    user selects product A on a form, I want product B to automatically be
    updated and selected. I know that this code should be on the 'after update'
    property of the check box. But that is all I know.

    I want to run an If/then statement, but get completely lost on the
    terminology and coding. If anyone has any suggestions, that would be great.
    Also, if its possible to use example code (and clarify which variables I will
    have to change according to my own names of fields), I would hugely
    appreciate it.

    Thanks!!
     
  2. Loading...


  3. Rick B

    Rick B
    Expand Collapse
    Guest

    Please don't post the same question to more than one group.

    http://www.mvps.org/access/netiquette.htm

    --
    Rick B



    "aheath15" <aheath15@discussions.microsoft.com> wrote in message
    news:67F94B07-74FF-4680-8AD4-06DD0241368D@microsoft.com...
    > still stuck on the same problem:
    > I have a table of products, from which a user can create an order by using
    > a
    > form, and checking off the products they want. I need to create a code
    > that
    > automatically selects another product if one specific product is selected.
    >
    > For example, say product A requires that product B be selected. So, when
    > a
    > user selects product A on a form, I want product B to automatically be
    > updated and selected. I know that this code should be on the 'after
    > update'
    > property of the check box. But that is all I know.
    >
    > I want to run an If/then statement, but get completely lost on the
    > terminology and coding. If anyone has any suggestions, that would be
    > great.
    > Also, if its possible to use example code (and clarify which variables I
    > will
    > have to change according to my own names of fields), I would hugely
    > appreciate it.
    >
    > Thanks!!
     

Share This Page