Thanks Namliam
I have had a look at those examples and they seem to be doing it the same way i am.
Do you have an example of doing the query in vba as i am still struggling to find one
Thanks
Wow if only it was 5 years ago. But i will ask a question any way.
This is what i am struggling with and am using the same method but in a slightly different way.
The problem i have is that when you have
Like *
It does not show the records that have Null in that field
I need it for be...
I am still having trouble with this.
What i need to know is can you pass
Is Null
Or Is Null
From a field to criteria of a query
When i am trying to
when the check box is True i have the folowing Forms!frmreport.fldname = "requiredtext"
This is then the statement i have in the query...
Hi
I have a Report form where i can select selection criteria for a query. The form name is frmreport and the field is fldmachine. I also have a check box that enables and diasbles this field.
In the query criteria i have
"Like Forms!frmreport.fldname"
when i select the type of machine and...