Search results for query: *

Whenever I view a query, or a subform in datasheet view, when I click the filter icon the drop down pops up with only about 10 rows of data. I would like to change the default rows to about 20 rows or so. Of course the top of the filter pop up will still have the sort order choices, select...

Thanks PHV! That did the trick! I also found that looking at this situation from the main form, by defining the text box Control Source property to: =[subfrmIS-3a].[Form]![qryIS-1.Link2] that seems to work also. Would either of these be a preferred way of synchronizing, for performance or...

I see a way of doing just what I need with input from MajP in thread702-1201740 to sync two subforms on a main form. However, I seem to keep getting the following error: Runtime Error ‘2465’: Microsoft Office Access can’t find the field ‘txtBxBtoC’ referred to in your expression. I've added a...

Hi, Eupher! Thanks again for the quick response. This is an interesting solution. It will take me some time to test this one out, but I’ll get back with you and let you know how it went. Bubba02

Hi, Eupher! Thanks again for the quick response. I want to apply the conditional formatting on a subform with a ‘Continuous Forms’ view. When the subform is set to datasheet view, the formatting doesn't seem to apply. Hard-coding things every time I build an object is an error prone work...

Hi, Eupher! Thanks for the quick response. You cleared up something right away for me stating that ControlSource is not a property of the form object, but the [Me] self-identifier apparently is. I thought that the [Me] self-identifier could also be used for text box control references as part...

Using Access 2002, I want to compare the data in table1 to the data in table2 as part of a form's conditional formatting expression. These two tables have identical structures. I thought that the "Me" self-reference could help with this, but perhaps my syntax is not right, or this is not...