Help with Subform

[sneakyfast]

Version of Access: 2007
Skill Level: Beginner



The database project I am working on seems somewhat basic but I continue to struggle. The intent of the database is to select products for various rooms in a office building. I have configured the following tables.

tblRooms
==================
RoomNumber Primary Key
RoomName

tblProducts
==================
ProductTag Primary Key
ProductType
ProductManufacture
ProductMake
ProductModel
ProductPrice
Description

tblFurnitureSelection
==================
ID Primary Key
RoomNumber link to tblRooms
ProductType link to tblProducts
Quantity

What I an trying to setup is to have a main form show the current room name and number I need to select products. Also on the main form would be a mutiselect list box which would allow me to select the products from the list and have them populate the subform with the products selected. Then all I would have to do is enter in the quanties.

With my subform now, I have to individually select each product as a new record. I would like to select the products I needed from the list box and have it populate the subform.

Any help is appreciated.

[maximus]

I don't know whether your problem is solved I will be happy to buil the database for you contact me at silverback_bats@yahoo.co.in with details.