R
Rod Behr
In my previous question, I asked how to set the RecordSource property for a
subform. Having got this right, I now want to filter (for a date) for one
RecordSource, but not the the other. I have a button which switches between
two RecordSources, one I want date filtered, one I don't.
So I want to set the LinkChildField and LinkMasterField properties for the
subform to field [Date] (both fields are called [Date]) in the first instance
and to Null in the second.
Using SetValue:
forms!Form!SubForm.Form.LinkChildField = "Data"
Returns error "Can't find the field 'LinkChildField' referred to in your
expression.
As I spelling LinkChildField incorrectly or is there something else? I
obviously need to do the same for LinkMasterField.
subform. Having got this right, I now want to filter (for a date) for one
RecordSource, but not the the other. I have a button which switches between
two RecordSources, one I want date filtered, one I don't.
So I want to set the LinkChildField and LinkMasterField properties for the
subform to field [Date] (both fields are called [Date]) in the first instance
and to Null in the second.
Using SetValue:
forms!Form!SubForm.Form.LinkChildField = "Data"
Returns error "Can't find the field 'LinkChildField' referred to in your
expression.
As I spelling LinkChildField incorrectly or is there something else? I
obviously need to do the same for LinkMasterField.