Filtering in Forms

[djclntn]

Am I correct that in a Form you cannot filter a particular field, save & close the Form, & then reopen the Form as it was previous filtered, right? I have a Form in datasheet view being one of the fields contains the Mnthyr (Month/Year). I only want to see the current mnthyr records when I open the Form (which contains a sub-form within.) I’m trying to avoid A) having to filter this mnths records each time I open the Form & B) I really don’t want to create/save a new Form every month. Might anyone have any suggestions?
Thanks in advance.

[orange]

Dave,
A bound form is associated with a table or query in that the "recordsource" of that form identifies the fields and values available to the form. When you open such a form again, as long as the recordsource of the form is the same, you should have the same data.

The "recordsource" is basically the means by which data is made available to a Form. Could be a table, could be a query,or could be an SQL statement. When you filter a form, you are modifying the recordsource.

Suppose you had a query - SELECT Name, address from PersonTable ---which would give you all the Names and addresses for all People in the PersonTable and it was the recordsource of a Form.

If/when you filter that "data" to only have those people with names starting with "C" -- the query is modified as

SELECT Name and Address from PersonTable WHERE Left(Name,1) = "C"

So it's the data available to the form that is filtered.
The data is not saved with a form. Data resides in tables. Tables can be viewed/seen by queries.

Hope that helps

[djclntn]

Hey Orange, thanks for replying to me. Yea I hear what you're saying; unless I filtered out the current month in the query then that's pretty much my option.

[orange]

You should really store dates as Date/Time datatype. Your mnthyr doesn't sound to be a Date datatype.

What sort of data is in Mnthhyr?

Could be something like

Select all your current fields FROM Your Table
where
Month(MnthYr) = Month(Date) and
Year(mnthYr) = Year (Date)

[djclntn]

No Orange, my "mnthyr" is a Date/Time Datatype." I have the month & year combined, "mmyy" are you suggesting that I ought to have them separate (in 2-seperate Fields)?

[orange]

No not separate fields. What is a typical entry in your MnthYr field?

[djclntn]

Orange, the Mnthyr field it's not an entry.; it's derived from the "Date" entered. In the Date field: 3/21/2013. Then in the 'MnthYr' field is: 03/13.

[orange]

If you derive MnthYr from some date, and you want only records from the current month and year, then
my sql above should work IF you replace the MnthYr in the sql with the name of the field from which you derive MnthYr.