Recent content by KevinAnderson

I use access 2003 and would like to know if its possible to count records that i have displayed on a form and store the results in a textbox on the same form. More than that I have a field that can contain one of three values for this examples lets just say the values are "Red" "White" and...

I get the following error "#Name?"

That expression can go in the control source box? Doesnt seem to be working for me. thanks for the continued help

Will this code update the textbox when i Highlight a different record in my subform?

It needs to remail in a a datasheet view. Any other options.

I have a form that lets you select an employee name from a combobox. When you select the employee name a subform populates in a datasheet view with the Name, record ID, and the last column contains a description of the record. As a datasheet view is not good for reading these messages i want to...

Perfect... thank you for all the feedback!

Still using 2003 until this may. When I code to display the hidden control and set focus to it I get an error message stating that Access can not change focus to control calendar1 ect..

I currently have several forms that make use of the calendar control by linking it to a combobox. When the combo box is clicked the calendar displays itself. However, I am attempting to do the same in a form that uses the datasheet view. The date column has been set up as a drop down, but the...