Search results

  1. A

    #error in main report textbox when in report view

    There is a textbox that uses iif(sub.report.hasdata,sub.report.value,0) expression in the main report (main) to retrieve calculated field data in the subreport (sub). The sub has another 4 subreport. When in report/print view, #error shows in the main textbox. In layout view, when the sub is...
  2. A

    Error 2115 when using combobox to filter subform

    Hi I have a combobox that takes data from table 1 and using select where function filters the subform that takes data from table 2. when i use this code in Private Sub cmb_ClientName_AfterUpdate() Dim sql As String sql = "SELECT * FROM qry " _ & "WHERE qry.[CLIENT NAME] = '" &...
Top Bottom