I was just doing my own database and found that I can actually filter multivalue field using the IN() operator.
Basically I was filtering a multivalue field named "Workyears"
So the filter is:
rs.Filter = "[Workyears.value] IN" & "(" & wy & ")"
(since I gather that .value will string the result...
Excellent solution arnelgp !!! Why didn't I see this "acCmdFormHdrFtr" when I was scrolling the docmd.runcommand
Anyway, I also came up with another solution which is to create a form with the header "evoked" and use it as a template in the
Set frm = CreateForm(, "MyForm") where "MyForm" is a...
Good Afternoon, I am using a subroutine to create a new form and also a label at the "Header" section. The routine below works only if I use the default to create the label control in the Details section. However, it will shows an error if I try to add the label control to the "Header" section...
Hi, you can only use sum([TXTAMT]) in a report format assuming the TXTAMT points to a data control source.
For a "Form" format, you can use DSUM function which should be as follows:
TXTTOTAL= DSUM("[TXTAMT]", "tbl_Name or Qry_Name") ' Note that invert comma positions. Also no criteria...