L
Liz
I'm brand new to Access and hopefully I'm not too in over my head. I have a
main form with a multi select list box and a combo box. The multi select
list box contains part names and the combo box contains part numbers. I
would like the user to be able to multi select part names and have new
records for each part show up in the subform. The user should also be able
to use the combo box to pick a part number and the same action will happen.
Then the user can put in the new information (no changes to the part name or
number -- just entering information in other column fields about it) and it
is stored in a table. I have a parts table that stores the part names and
numbers with a one to many relationship to the partinfo table that will store
the user entered data.
I've been reading about using the items selected in VBA code but since I'm
new I don't know exactly how to implement this. Any help is greatly
appreciated and the other posts have been extremely helpful!
PS Sorry if this is posted twice - I couldn't tell if it took the first time
main form with a multi select list box and a combo box. The multi select
list box contains part names and the combo box contains part numbers. I
would like the user to be able to multi select part names and have new
records for each part show up in the subform. The user should also be able
to use the combo box to pick a part number and the same action will happen.
Then the user can put in the new information (no changes to the part name or
number -- just entering information in other column fields about it) and it
is stored in a table. I have a parts table that stores the part names and
numbers with a one to many relationship to the partinfo table that will store
the user entered data.
I've been reading about using the items selected in VBA code but since I'm
new I don't know exactly how to implement this. Any help is greatly
appreciated and the other posts have been extremely helpful!
PS Sorry if this is posted twice - I couldn't tell if it took the first time