Bound form acting strangly

[WilliamAstarita]

My database has its own contact system. I've emulated a form to look
exactly like the outlook contact window. When I use the form as a
subform, the sort headers worked fine but the filter boxes do not.
They get focus but typing into them displays no text like the keydown
event was canceled.

The sort headers are simple lables that when clicked changes the
Orderby property of the form.

The filter boxes add a where clause to the form's recordsource query.

Then when I use the form as a standalone form, the sort headers don't
work but the filter boxes work fine. There really isn't anymore to the
coding than I've described. I then figured out that I had the parent
form set to AllowEdits = False. It seems subforms inherit (So to
speak) the parents characteristics. I changed that, now its broken the
same way regardless of whether I run it as a form or subform, the
filter works but the orderby property does not. Any ideas?

 

[Marshall Barton]

My database has its own contact system. I've emulated a form to look
exactly like the outlook contact window. When I use the form as a
subform, the sort headers worked fine but the filter boxes do not.
They get focus but typing into them displays no text like the keydown
event was canceled.

The sort headers are simple lables that when clicked changes the
Orderby property of the form.

The filter boxes add a where clause to the form's recordsource query.

Then when I use the form as a standalone form, the sort headers don't
work but the filter boxes work fine. There really isn't anymore to the
coding than I've described. I then figured out that I had the parent
form set to AllowEdits = False. It seems subforms inherit (So to
speak) the parents characteristics. I changed that, now its broken the
same way regardless of whether I run it as a form or subform, the
filter works but the orderby property does not. Any ideas?

Barring corruption, all I can think of is that you might
have forgotten to set the OrderByOn property.

If that's not it, and I assume it is not, please post your
code. Because we can't debug subtle code issues without
seeing the code you're actually using, please use Copy/Paste
so we don't waste time debugging any typos.