Search results

nope it doesnt. thanks for the reply. i tried opening the subreport then open the main report, and the value appears correctly

there isnt OnPrint or OnFormat events in the property sheet. thanks for the reply. i tried opening the subreport then open the main report, and the value appears correctly

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

hi! this is the error "The macro or function set to the beforeupdate or ValidationRule property for this field is preventing the DB from saving the data in the field. " it highlights this line Forms!main.subfrm.Form.RecordSource = sql

i dont understand, pls explain in more detail ur reasoning behind these codes. actually why did the error comes up? i'm using afterupdate not beforeupdate. then should i change the subform source to qry 2 also?

Why need to create a unbound textbox with the same values that will appear in the combobox? what is the recordsource for? is it to create another query (qry 2) with the same records as the one i have in the original query (qry 1), just that now there is a criteria in qry 2 with...

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] = '" &...