Setting a recordsource to null

  • Thread starter Thread starter Stephen English
  • Start date Start date
S

Stephen English

I know how to set a recordsource of a subform in code.
but... How do I set it to null
The situation is that I select a customer and then on
another tab enter some search parameters for products and
then set the recordsource of the subform to an appropriate
SQL statement. Works fine
However, when I select another customer, I want to set the
product SQL to Null
Me!frmProdSearch.Form.RecordSource = Null doesnt seem to
work.
Any suggestions please?
THanks
Stephen
 
Stephen,

It is impossible to have a Null recordsource. Try...
Me.frmProdSearch.Form.RecordSource = ""

- Steve Schapel, Microsoft Access MVP
 
Back
Top