Hi!
I'm creating a form for new product setup. In this form I have first combo called Product, second combo called Type and third is a list box called Spec. All these 3 boxes are linked. Both "Type" and "Spec" will contain similar criteria.
e.g. for Product "Filter" or "Pump", both can have similar Type, i.e. Air or Water. Same goes to "Spec".
I've managed to create up to the last requirement where Requester first choose the "Product" follow by "Type" and the list box will populate a list of "Spec". But my problem is the field "Spec" are not recorded or bound to the table so when I wanted to print out the report, it wont shows the Spec value.
The "Spec" criteria range from min. 1 to max. 17 for different Product Type.
I wanted the "Spec" to auto populate as in text field and also a blank text field for requester to fill in the spec value.
Does anyone here would able to give me an idea????
btw, i'm using Access 2010 version.
Any help would be greatly greatly appreciated.
I'm creating a form for new product setup. In this form I have first combo called Product, second combo called Type and third is a list box called Spec. All these 3 boxes are linked. Both "Type" and "Spec" will contain similar criteria.
e.g. for Product "Filter" or "Pump", both can have similar Type, i.e. Air or Water. Same goes to "Spec".
I've managed to create up to the last requirement where Requester first choose the "Product" follow by "Type" and the list box will populate a list of "Spec". But my problem is the field "Spec" are not recorded or bound to the table so when I wanted to print out the report, it wont shows the Spec value.
The "Spec" criteria range from min. 1 to max. 17 for different Product Type.
I wanted the "Spec" to auto populate as in text field and also a blank text field for requester to fill in the spec value.
Does anyone here would able to give me an idea????
btw, i'm using Access 2010 version.
Any help would be greatly greatly appreciated.
