When Form Opens I get the following, The expression is typed incorrectly . . . .

[MFS]

Not sure if I'm starting this thread in the proper location,
Anyway, prior to or when my form opens I receive the following . . .
"The expression is typed incorrectly, or is to complex to be evaluated. So on and so on"
The reason for this is is because there happens to be a graph and a subform that is looking for information that is typed into textboxes after the form is open. (Query Criteria)


So what are my options to keep this message / information box from appearing?

[hapm]

The reason for this is is because there happens to be a graph and a subform that is looking for information that is typed into textboxes after the form is open. (Query Criteria)
So what are my options to keep this message / information box from appearing?

Than fix the expression you use in that graph/subform. Or post it here so we can help you to fix it.

[atuhacek]

You could try disabling them and having a after update event that enables and requery after data is entered.

[MFS]

Here's what I did,
I wrote "Enter Data" in each field on one row in my table and then entered a date of 01/01/2001, which has never been used.
Then entered 01/01/2001 for the Default Value of the 'date' fields text box.
Now when the form opens the textboxes all say Enter Data with a date showing 01/01/2001.
I know this is a weird way around this but it works, plus prompts the user to enter data in the textboxes.

[atuhacek]

If your going to go that route you need to do all your filtering with vba in the background. either add a button to execute or an event.