I have one form with a subform. The subform is being displayed as a datasheet. When I click on the arrow in a column header I get a series of boxes that I can check or uncheck to filter the datasheet. I have another form/subform setup (I believe) the exact same way, however the filter checkboxes do not appear when I click on the column header arrow. The subform that isn't working has fewer records. Does anyone know what turns this functionality on and off? Thanks!

Open the Access Options box, and click Current Database in the list on the left.

At the bottom, there is something you can set that I believe turns the dropdown lists on and off. Filter lookup options for DietaryBE (or whatever name) Database

If I am correct, those options may be unchecked.

It may also be that you cannot do this at all with a linked table, possibly because the table indexes are not available.

Hi fkegley,

Thanks for the reply.

I don't think that's the problem since the tables are not linked and the form/subform that is working is in the same database and the one that isn't.

Eightball3, I don't remember where I got these directions (possibly even here) but here is how to turn the arrows off and on.

Open the datasheet form in Design View and then open the Property Sheet for the form.
Look for the property called Shortcut Menu on the Other or All tab of the Property Sheet.
Change that property to No, save the form, and now switch back to Datasheet View.
Access now removes the arrows from the top of the column headers.
Change the property to Yes to turn them on.

Have fun!

If you look in the Property Sheet of the Main Form, Click on the Data Tab, then near the bottom there is "Allow Filters." If this is set to No, change it to Yes.

Thanks River34,

I'm not having trouble turning the menu off and on. The problem I'm having is when it's on, the check list boxes are not there. I have the filter lookup options for the database set to 10,000, and there are 1300 records in my database. Every field in the underlying table is indexed. These are NOT linked tables. I have one form/subform that works and one that doesn't in the same database.

Thanks RaZMaddaz,

Both the main form and subform allow filters is set to "yes" on the one that works as well as the one that isn't.

Then if click on the outside of the Sub Form and view the Properties, click on the Data tab, is there anything in the Link Master Fields and Link Child Fields?

Edit: And does Enabled say "Yes?"

Nothing in either field and enabled is set to "yes"

Click on the .... next to the Link Master Field, a window will appear called the Subform Field Linker and then choose a Field from the Master Fields and a Field from the Child Fields in which the Forms/Tables/Query's are related.

The main form is unbound so an error message appears.

How can the Main Form be unbound? I assume not, but are you showing any Fields from a Table or Query on this Main Form?

I understand, so you placed another Form with data from a Query or Table into an Unbound Form and for some reason you can't filter the Sub Form. Correct?

The main form on both the form/subform that works and the one that doesn't is unbound. No I show no fields from a table or query on the maoin form.

I can filter the subform however the check list boxes do not appear. I get the other options like "Text filters", "Sort AtoZ", "Equals", "Does not Equal" etc. Just no check boxes to check.

Perhaps it's time to post an example of what you are doing (make sure no sensitive information). This will help someone here to help you solve your problem. Believe me, if there is an answer out there, Raz will find it! He's kind of like that.

I would try placing your Sub Form onto a new blank Form, just to see if it you can see any of those check boxes. BTW, if you open the sub form by itself, can you see any of the check boxes in the Filter?

EDIT: Sorry for misunderstanding you!!!!!!!!!!

RAZMaddaz and everyone else, I really appreciate your help!

I found the problem, although I'm not quite sure why. In the query of the underlying subform the "output all fields" was set to yes. I changed it to no and things seem to work now.

Thanks again for all the help!!

If that still does not work, then I would do what River34 suggested and that is make a copy of your dbase, delete all private data, zip the new dbase and upload the zipped file. Someone will take a look and get back to you ASAP.

RAZMaddaz

Awesome!!!! Glad you got it fixed. You might want to check to see if you had somehow had this set as the default for this database. Go to Access Options - Object Designers and under Query Design, make sure "Output All Fields" is not checked.


Edit: BTW, I see this is what the great Frank suggested originally.

RAZMaddaz