I am trying to open a report using the 'where' criteria with an 'and' condition
strWhere = "[leagueno] = " & Me![leagueno] & " And [Team] = " & Me![Team]
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.OpenReport "rptFixtureList", acPreview, , strWhere
this throws up a dialog asking for the exact parameter in the 'and' condition
any help will be appreciated
thx
Geoff