Recent content by wattsaj

Syntax error message on query I am also tryinbg to get a query to give me elapsed time excluding non-working hours and weekends so I tried this module and used a table called 'TblTimes' with a 'requesttime' field and a 'responsetime' field. I changed the appropriate text in the query to CT...

Thanks, however I wnat to use the same form and subform again but apply a different filter if a different button is selected on the menu form, so I dont want to put the code in the Row source of the combo box as it can change. I believe I therefore need the code on the event procedure to open...

Can anyone help me with some apply filter code? On clicking a button to open a form I want to filter a list in a combo Box located on the main forms subform The main form is called 'Frm_orders' The sub form is called 'sub' on the form but 'Fsub_OrderDetails' The combo box field is called...

On clicking a button to open a form I want to filter a list in a combo Box located on the forms subform The main form is called 'Frm_orders' The sub form is called 'sub' The combo box field is called 'CostCodeID' and I want to filter column 0 of the combobox which is Tbl_InvoiceCostCodes.Type...