On Aug 17, 1:04 am, Duane Hookom <duanehookom@NO_SPAMhotmail.com> wrote: You would use something like: (Problem.ShopID=Forms!frmSearchrpts!cboFilter1 Or Forms!frmSearchrpts!cboFilter1 Is Null) -- Duane Hookom Microsoft Access MVP "Opal" wrote: On Aug 15, 11:44 pm, Duane Hookom <duanehookom@NO_SPAMhotmail.com> wrote: I wasn't kidding when I suggested
On Aug 15, 11:44 pm, Duane Hookom <duanehookom@NO_SPAMhotmail.com> wrote: I wasn't kidding when I suggested you needed to set the data types of the parameters. Did you try it? -- Duane Hookom Microsoft Access MVP "Opal" wrote: On Aug 15, 4:19 pm, Duane Hookom <duanehookom@NO_SPAMhotmail.com> wrote: If you have a crosstab query, you must specify the data
I wasn't kidding when I suggested you needed to set the data types of the parameters. Did you try it? -- Duane Hookom Microsoft Access MVP "Opal" wrote: On Aug 15, 4:19 pm, Duane Hookom <duanehookom@NO_SPAMhotmail.com> wrote: If you have a crosstab query, you must specify the data types of all parameters. For instance Forms!frmSearchrpts!txtEndDate Date/Time
If you have a crosstab query, you must specify the data types of all parameters. For instance Forms!frmSearchrpts!txtEndDate Date/Time Forms!frmSearchrpts!txtStartDate Date/Time -- Duane Hookom Microsoft Access MVP "Opal" wrote: On Aug 15, 12:41 pm, Duane Hookom <duanehookom@NO_SPAMhotmail.com> wrote: Can you provide some information about your report's record source
Can you provide some information about your report's record source and the chart row source? Did you see any chart display when the link properties were blank? -- Duane Hookom Microsoft Access MVP "Opal" wrote: On Aug 15, 11:41 am, Opal <tmwel...@hotmail.com> wrote: On Aug 14, 9:51 pm, Duane Hookom <duanehookom@NO_SPAMhotmail.com> wrote: