S
Sandy
I have a form and subform created from the following tables:-
tblRepairCategory
RepairCategoryID (Primary Key - Autonumber)
RepairCategory (Text) - on form main (frmCategory)
tblRepairType
RepairTypeID (Autonumber)
RepairCategoryID (Number - Long)
RepairType (Text) - on form (subfrmRepairType)
BuyPrice (Currency) - on form (subfrmRepairType)
SellPrice (Currency) - on form (subfrmRepairType)
form objects are:-
Main Form - frmCategory
"txtRepairCategory"
Subform - subfrmRepairType
"txtRepairType"
"txtBuyPrice"
"txtSellPrice"
My question is how can I change the text box 'txtRepairCategory' to a Combo
box that would select the correct details on the subform.
Sandy
tblRepairCategory
RepairCategoryID (Primary Key - Autonumber)
RepairCategory (Text) - on form main (frmCategory)
tblRepairType
RepairTypeID (Autonumber)
RepairCategoryID (Number - Long)
RepairType (Text) - on form (subfrmRepairType)
BuyPrice (Currency) - on form (subfrmRepairType)
SellPrice (Currency) - on form (subfrmRepairType)
form objects are:-
Main Form - frmCategory
"txtRepairCategory"
Subform - subfrmRepairType
"txtRepairType"
"txtBuyPrice"
"txtSellPrice"
My question is how can I change the text box 'txtRepairCategory' to a Combo
box that would select the correct details on the subform.
Sandy