Limiting a datasheet subform based on a date/box?

[simpleton]

I have a form that shows a datasheet subform, but i need to have a little "date" box up top where I can have the data limited by the date.

Nothing is working.

Where should the parameter live? I tried putting it in the datasheet's query and referencing the date box.. like =[Forms]![Admin]![Date] but the form gets angry about that.

What direction should I take?

 

[Dennisk]

what is the form's angry message to you?

 

[simpleton]

I realize that i'm probably doing this all wrong.
So i'm fine to start over on this form.
I just don't know what direction to head.

Here's the error i was getting on my bad-version....

First off, it doesn't want to load... it prompts me for the [Forms]![Admin]![Date] information... and then when i update the Date field (calling a requery), it says "The expression After Update you entered as the event property setting produced the following error: A problem occurred while Main was communicating with the OLE server or ActiveX Control."

 

[gemma-the-husky]

you either need to use the date as a filter (in which case your record selector will show record 4 of 12 (filtered)

or use the date as a selection criteria in the query ((in which case your record selectrr will just show record 4 of 12


----------
pros and cons of each method - but i tend to use the latter, on the basis that getting less data is more efficient - but i am not really sure if there is a difference

 

[simpleton]

But what i really want is a date parameter on my datasheet data.