selecting data from 2 tables to a 3rd table using a form

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Lucas45
    New Member
    • Feb 2008
    • 2
    #1

    selecting data from 2 tables to a 3rd table using a form

    Hi I am a newbe at this
    I have created 3 tables one called computers the other software- and the third installed apps What I am trying to do via a form is to have on the one side a combo box showing the p/c names, and on the other side a combo box showing all the apps. What I am trying to do is to select a pc name from the p/c name combo and then selecting a few apps from the other combo box (installed aps) and this info is written to a table showing the p/c name and the apps associated with it.
    thank you
    Tags: None
    • Delerna
      Recognized Expert Top Contributor
      • Jan 2008
      • 1134
      #2
      Hi Lucas 45 and welcome.
      Thats a big question to try and answer in a forum.
      What have you tried in order to achieve it so far?
      What difficulty are you having making it work?

      I assume you are going to display the list of applications on the form for the selected computer and that as you select an application in the combo box it will be added to the list displayed on the form
      If so then what you are trying to achieve will probably need to be done with some VBA code on your form. How familiar are you with VBA?

        Comment

        • Lucas45
          New Member
          • Feb 2008
          • 2
          #3
          Originally posted by Delerna
          Hi Lucas 45 and welcome.
          Thats a big question to try and answer in a forum.
          What have you tried in order to achieve it so far?
          What difficulty are you having making it work?

          I assume you are going to display the list of applications on the form for the selected computer and that as you select an application in the combo box it will be added to the list displayed on the form
          If so then what you are trying to achieve will probably need to be done with some VBA code on your form. How familiar are you with VBA?
          Hi Delerna
          Thank you for your reply. You are correct in that I will need to do some VBA coding. In Essence what I am trying to achieve is updating a table by using 2 other via combo boxes. I guess I have to find a way In VB to read a: the computer name from the one Combo as well as the selection made in the other combo box and write the data into a third table. I can then do a query on that table. Looks like I have to brush up my VB.

            Comment

            Previous template Next
            Working...