The "Filter" controls for the columns in a Split-form Table have disappeared

[c.d.power]

I have a split-form and the filter controls for the table have disappeared. At the bottom of the Access window, it says that there is "No Filter" which makes sense. I've tinkered with a few of the settings on the form with no luck. I also looked at the source table to see if something was off but couldn't find anything.

I do have some code associated with the form; see below:



Private Sub cmd1149RunReport_Click()
DoCmd.OpenReport "rpt1149", acViewReport, , Me.Filter, acDialog


End Sub

This is really what I need the filter controls for - to filter the data I want and run the report for only that data.

Thanks in advance!

[June7]

Why would the datasheet column filters not be available? Are for me. Not sure where you see "No Filter". I see "Unfiltered" on the form.

[c.d.power]

Thanks for replying. I've attached to screen captures; one of the form that isn't working and another for a form that's working properly. As you can see, one of the form as the filter controls (the downward arrows) affixed to the columns. For whatever reason, the form I'm having trouble with doesn't have them, although it did at one time.

[June7]

Check the form ShortcutMenu property. Must have been set to No.

[davegri]

The "downward arrow" indicates the control is a combo box. Go to design view for the 1149 form and look at the controls properties.

[c.d.power]

Check the form ShortcutMenu property. Must have been set to No.

That did it! Thank you for your help. Not sure how that happened.