Search results

  1. H

    IIF statement calculation

    HI i am trying to update a field by clicking a command button on my form. My problem is that this iff statement does not work if i calulate txt cubic *167 if i take away the *167 the statement works. Not working Private Sub Command80_Click() Me.Air_actual = IIf(([txt cubic] * 167) > [txtkgs]...
    • hedge
    • Thread
    • Replies: 1
    • Forum: Forms
  2. H

    filter combo1 based another combobox

    I have 3 comboboxes that filter a subform on afterupdate and now I need to filter the second combo based on the value selected in the first combo. I am not sure if i need to add code to the below. Or use another event and if so what i code i need. Private Sub RunFilter() Dim strFilter...
    • hedge
    • Thread
    • Replies: 2
    • Forum: Forms
  3. H

    filter subform with combo boxes

    i have searched the forum and found this example similar to what i am trying to achieve. http://www.access-programmers.co.uk/forums/showthread.php?t=157601 i have a search form (consignment Search) with 5 combo boxes i would like to use to filter a subform (Consignments Details). I have copied...
    • hedge
    • Thread
    • Replies: 4
    • Forum: Forms
Back
Top Bottom