Recent content by hedge

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]...

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...

Thanks for the help. 1/james tried the text boxes your right each box had to be filled in so that did not suit. 2/ Trevor tried you code, just getting stuck on the red area as a compile error Private Sub Command28_Click() 'This code will look to filter records in a subform 'It is using 8...

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...