Setting a recordsource to null

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
 
S

Steve Schapel

Stephen,

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

- Steve Schapel, Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Form recordsource parameter sp change 2
After changing the recordsource of a form, Disabling a button 1
changing recordsource continuous subform in vba 2
Subreport Recordsource problems 2
SourceObject and RecordSource 8
Error when attempting to set subforms recordsource programatically... 2
Setting recordsource property in VBA Access 2007 7
Subform's RecordSource under Access 2007 sp1 2

Top