Filter out empty fields(Text boxes) after changing control source.

[Ramun_Flame]

So, I want to filter out a form based on the value in a text box. The text box is called details, and it changes control source based on buttons. When it changes control source, I want it to filter out the blank text boxes. If I filter by the control source, it takes forever to load, so I want to try filtering by the text box values.



I tried this:

DoCmd.ApplyFilter , "Not isnull([Details]) AND (Student_Name = 'Cancelled' OR isNull(Student_Name)) " & " AND CDate([Day] & ' ' & [StartT]) BETWEEN #" & Now() & "# AND Date() + 8 "


The text box is called [Details], but it doesn't recognize it, and asks me for it's value.

Is there any way to do this?

Thank you.

[rpeare]

if that's your statement you have a problem on the end of the line. You have:

.... + 8"

when it probably should be

... + 8 & "#"

[rpeare]

One other thing to mention, instead of applying a filter you can probably build your form on a query and have the criteria of the query be the two variables you have shown.

[Ramun_Flame]

It's using two tables, so if I build it on a query, I can't enter values in the form. The date part works fine, it's just the text box.

[rpeare]

"Not Isnull([Details]) AND ([Student_Name] = 'Cancelled' OR isnull([Student_Name])) AND CDate([Day]) Between #" & date() & "# AND #" & date() + 8 & "#"

(I don't use filters but this is my best guess and works when I apply it to a test form)

With regard to you using two tables, if the items on the tables are related use a form/subform for your data entry.

[Ramun_Flame]

Like I said, the date part works fine. Details is not a field in my table, it's the name of a text box I'm using and changing to control source of.

When I try this:

DoCmd.ApplyFilter , "Not Isnull([Details])"

It asks me for a value for Details.

I think it's looking for details as if it is a field in the table. How do I make it look for a text box?

Edit:

Don't need to do this anymore. Thanks anyways for the suggestions.

[rpeare]

is details an actual field on your form, check the NAME, not the CONTROL SOURCE.

[Ramun_Flame]

Details is the name of the text box, there is no field details in my table. I found out that you cannot filter based on the textbox name, only table fields, and I don't even need to do this anymore.