Subform Help Please 1

[fsupport1600]

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 classrooms in a school. I have configured the following tables.

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

tblProducts
==================
ProductTag Primary Key
ProductType
ProductManufacture
ProductModel
ProductModel
UnitPrice
Description

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

I have created a subform based off the Funiture Selection Table. I placed this subform on a main form that shows the room number and room name. The intent is to use the subform to select the products and quantities for that room.

The subform has the ProductType drop down selection list and the quantity input field. Is their a way when a product is selected from the list it will display the other fields in the Products table like Product Manufacture Product Model, Product Model.

Any help is appreciated.

Thank You

 

[dhookom]

You can set the Row Source of the ProductTYpe row source to something like:

SELECT tblProducts.prodTagID, [prodType] & ": " & [prodManufacture] & ": " & [prodModel] & " " & Format([ProdPrice],"Currency") AS Expr1
FROM tblProducts
ORDER BY [prodType] & ": " & [prodManufacture] & ": " & [prodModel] & " " & Format([ProdPrice],"Currency");

Set the number of columns to 2 and the column widths to 0,2.

Also, isn't the field in tblFurnitureSelection "prodTagID"?

Did you change the field type of RoomNumber so they are both the same?

Duane
Hook'D on Access
MS Access MVP