[AccessD] Changing Subform Record Source

Dear List:
 
Trying to change the record source on a sub-form and I can't ever remember
the correct syntax.  This
 
Forms!frmRoutings!sfrmRoutingSubForm.RecordSource = "Select * FROM
tblFinishingRouting " _
        & "WHERE fldPanelDefID = " & Val(Me.txtPanelDefID)
 
gives error object doesn't support this propertyor method.
 
I know I'm close but can't get it to work.  Anyone see what's wring?
 
MTIA
 

Rocky Smolin

Beach Access Software

858-259-4334

Skype: rocky.smolin

www.e-z-mrp.com <http://www.e-z-mrp.com/> 

www.bchacc.com <http://www.bchacc.com/>