I have the following union query behind a dropdown in access2007.
SELECT "(All)" As Section FROM tblCoversheets UNION Select [Section] FROM tblCoversheets WHERE CoverSheetDate = #" & Me.cmbDateTime & "#"
Me.cmbDateTime comes from a dropdown that list the coverheetdates
When I click on the combobox that should list the sections I get the following
error: the microsoft database engine could not find the object 'coversheetdate = #" & Me.cmdDateTime & "&".
I have no idea why I'm getting this error.
Any help is most appreciated.