OnPage2 ( Finance=financieel ) of MainForm ' Contracts ' , it is intended that a user makes a choice from the combobox: Rate1(=Tarief1),Rate2 , Rate3 , Rate4 or Rate5
In any chosen rate ( 1,2,3,4,5 ) in the main form ' Contracts ' a different hourly rate should be calculated in the subform by changing cboCategory " ContractBegroting/ContractFinancieel" at field Rate(=uurtarief) . This works fine.
The functionality I would like to add at is when the list box(cboTarief) on themain form mutates at a different rate ( for example: Rate1 to Rate2 ) that the hourly rate will change automatically in the subform Contractbegroting/ContractFinancieel, based on the corresponding category ( 1.2 , etc.)..Without changing cboCategory at the subform.
example :
-Selectionby user tab finance (MainForm Contracts ) for Rate1(=Tarief1)from cboRate/Tarief gives hourly rate 100 at Category1 ( =cboCategoryContractgebroting suformulier ) in the field Rate(=uurtarief). Now I would like to see when the user change cboTarief in Rate2(=Tarief2) in the ‘MainForm Contracts’ , without changing the cboCategory in the subform, that the field ‘Rate’ (=uurtarief) in the subform should automatically put the hourly 200 in the field Rate(=uurtarief), will based on Category1.