Filtering within forms

A

Alex

Hi I am running some filters on a mainform/subform.
The main form is based on a query
The first two work Ok, the third doesn't, and i cant work out why.

1.FilterField: DCount("*","tblRequests","[RecordID]=" & [RecordID] & " And
[FollowUpFlag]=False")
2.EnableFilter: DCount("*","tblSWPurchases","[RecordID]=" & [RecordID] & "
And [Software]='Enable'")
3.SCFilter: DCount("*","tblSWPurchases","[RecordID]=" & [RecordID] & " And
[Software]='The Shattered Crystal'")

I am getting an error: Field 'SCFilter' is based on an expression and cannot
be edited.

As far I can can see, all three are identically set up.

Can anyone tell me what is wrong

Thanks

Alex

PS have a good Holiday
 

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

Finding record on main form 1
Access "Enter parameter value" popping up in Access form 3
Syntax problem - can someone help me please 1
Hide/Unhide subform based on continuous subform 5
calulated field on main after filtering subform 1
Using a filter property as select criteria in a query 3
Working hours database: I'm going mad... 1
Place Value In Tag 2

Top