Subforms Splitting and filtering

[gg80]

I have a form with a narrow subform that is getting too tall. The subform consists of a list of items and prices with a fields for entering quantities.



I would like to shorten the list, by adding a duplicate subform to the screen. . The 1st subform would contain items starting with say, letters A-G and the 2^nd form with starting letters H-Z.

Since the ideal break point letter changes with time, I would like the operator to be able enter the break point letter on the parent form. I would also like the split to occur when the screen is first opened.

I tried the expression Me.Filter = "item > """ & [Forms]![ParentName]![BreakLetter] & """"
It works if I actuate it with a button, but not with subform onLoad or onAnything else

Any help much appreciated.

[June7]

Set the form Filter and FilterOnLoad properties.

The in code try:

Me.FilterOn = False
Me.Filter = ...
Me.FilterOn = True

[gg80]

Thanks much-this does it-someday I will know why. in messing around, I also found that it works if you list the code twce.

This site has changed, so I donh't see how to mark this as solved. Thanks again, much appreciated.

[June7]

Thread Tools on the menu bar above the first post.