I've got a form called FleetWork with a subform called WorkDetails. The form displays details of vehicles in the fleet. The subform displays records of work done on current vehicle displayed in the form. I've placed a combo box in the form's header which I use to look up vehicles. Everything works fine up to this point. The problem is that I would like to use this form to update the "work

I'm sure there are many other ways to complete your task, but the only other way I know of is to write some VBA Code to populate the Work Details sheet. "izzyt1972" wrote: That works wonders, but do you know how to make it so there are no gaps in the rows on Work details - Monday? That takes the data across, but if there are reg nos in F6 to F12, but only F6, F9, and F12 have an

If the ranges are the same size, thr placing this formula in WorkDetails Cell E6 =IF('Job Sheet – Monday'!C6=1,IF('Job Sheet – Monday'!U6="x",'Job Sheet – Monday'!F6,""),"") The single ticks ' are needed if the worksheet name has spaces. Make sure the "X" is the correct case ( UPPER or lower). Then you can select cell E6 and fill down to E29. Then in the same worksheet, cell