Results 1 to 2 of 2
  1. #1
    Office10 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2014
    Posts
    7

    ContractWebDatabase Form and subsform

    Attached a file from a contractwebdatabase.



    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.

    Unfortunately this does not work yet ...

    See attached ZipFile .


    Anybody knows how to fix this problem?
    Contracten.zip

  2. #2
    Office10 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2014
    Posts
    7
    Probably the previous file can't be read so here is another try, see attachement..
    Attached Files Attached Files

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums