filter on a calculated text box

[Sharon Hague]

Hi All

Can you not filter by selection on a calculated text box in a form?

I have tried it through queries and you can, however I can't seem to get it to work in a form.

Is this not possible.

Please advise.

 

[Rich]

Please stick to the original thread, are we now talking form or subform?

 

[Sharon Hague]

Rich

Sorry - But with Namliam not being able to help I didn't think anybody else was looking into this. Also with the last thread he did solve my first problem.

You mentioned form or subform - I have tried both ways and you have the same problem with both.

When you view either when you go on to a calculated control the filter by selection icon is greyed out.

 

[Rich]

Never use that method but, if you create a query and base the form on the query or the sql you can then use it

 

[Sharon Hague]

I thought that this would be the only way around it.

It seems daft though that you can't do this in forms created from tables without using queries.

Thanks all the same.

 

[Rich]

I do believe the preferred method is to base forms on queries anyway

 

[Sharon Hague]

I belive you are right.

However, I don't like ending up with loads & loads of queries used for one purpose only.

My forms are subforms created from tables as I don't need to raise a query for any part of these.