I have a form containing a button that opens form called e.g Cars. I have added VBA code to that button that opens mentioned form. However I would like to filter that form to records where field "IdGroup" has
[List0] value either is Null.
When I put WHERE conditions separately, I get an appropriate result for Null and for the value from
[List0].
DoCmd.OpenForm "frmCars", acNormal, , "[IdGroup] Is Null"
DoCmd.OpenForm "frmCars", acNormal, , "[IdGroup]=" &
[List0]
Both work fine, but I need to have WHERE combined out of those two. I got error when I put the following:
DoCmd.OpenForm "frmCars", acNormal, , "[IdGroup] Is Null" Or "[IdGroup]=" &
[List0]
I am almost sure I am not using OR operator correctly. It is probably quite easy but I cannot figure it out how it should be done.
I would be grateful for correction of the las VBA line presented.
Thank in advance,
Kind regards,
Paweł