K
Karl
Hello,
I'm trying to use base one combo box on another followed by a series of
subforms. I've figured out how to create the combo boxes I want using this
descprition http://office.microsoft.com/en-us/assistance/HA011730581033.aspx.
I’m trying to create something similar but instead of having both combo
boxes on the same form I want one combo box on the main form and another on a
subform within the main form. But I also want to be able to add other
categories to my forms besides the combo boxes (i.e. Category Id). I’ll use
link example for reference: I want Category to be a combo box in the main
form but I also want a text box that shows the category Id number of the
selected category from the combo box. I.e Beverages and Category ID 1. I
then want a subform that has products as a combo box but also shows the
product id in a text box. I want the product box to show only the values
associated with the category like in the example given on the website.
However I also want to add another subform to the product subform that links
a product properties (via property Id) table to the product that allows me to
view certain properties of a certain beverage. (i.e properties of Chai). I
want the property id to be an autonumber that updates the property id
everytime I add a new property to any product.
So in the end I want to be able to select a CATGEGORY from combo box (i.e.
Beverages). I then want the product combo box to only show only products taht
are beverages so I can select only select a beverage (I.e. Chai) . I then
want to be able to view the properties of Chai tea and if the property id
number update automatically when i add a property for any beverage. I also
want to be able to see the category id associated with the category name and
the product id associated with the a product as well as a properties id of a
certain beverage.
I would appreciate your assistance on this as I’ve tried everything I can
think of.
I'm trying to use base one combo box on another followed by a series of
subforms. I've figured out how to create the combo boxes I want using this
descprition http://office.microsoft.com/en-us/assistance/HA011730581033.aspx.
I’m trying to create something similar but instead of having both combo
boxes on the same form I want one combo box on the main form and another on a
subform within the main form. But I also want to be able to add other
categories to my forms besides the combo boxes (i.e. Category Id). I’ll use
link example for reference: I want Category to be a combo box in the main
form but I also want a text box that shows the category Id number of the
selected category from the combo box. I.e Beverages and Category ID 1. I
then want a subform that has products as a combo box but also shows the
product id in a text box. I want the product box to show only the values
associated with the category like in the example given on the website.
However I also want to add another subform to the product subform that links
a product properties (via property Id) table to the product that allows me to
view certain properties of a certain beverage. (i.e properties of Chai). I
want the property id to be an autonumber that updates the property id
everytime I add a new property to any product.
So in the end I want to be able to select a CATGEGORY from combo box (i.e.
Beverages). I then want the product combo box to only show only products taht
are beverages so I can select only select a beverage (I.e. Chai) . I then
want to be able to view the properties of Chai tea and if the property id
number update automatically when i add a property for any beverage. I also
want to be able to see the category id associated with the category name and
the product id associated with the a product as well as a properties id of a
certain beverage.
I would appreciate your assistance on this as I’ve tried everything I can
think of.