Actually, either will probably work, since you are using the ! instead of a period.
The [frmTo] part needs to be the name of the control on the main form that holds the
subform, not the name of the subform itself.
--
Wayne Morgan
"deko" <dj****@hotmail.com> wrote in message
news:Me***************@newssvr27.news.prodigy.com. ..
WHERE (tblTxJournal.TxAcct_ID IN (SELECT TxAcct_ID FROM tblTxAcct)) AND
(DatePart("q",[TxDate])=2) AND
(Year([TxDate])=[Forms]![frmMain]![frmTo]![cbxYear_To]) ...
is this okay, or should the last part be:
[Forms]![frmMain]![frmTo].[Form]![cbxYear_To])
Thanks in advance...