Search results

I am trying to requery a textbox on the main form by clicking in a checkbox control on a subform. The textbox counts the number of records on the subform that have the checkbox checked. I have it working by clicking a command button on the main form but I would like the requery to run every time...

Is it possible to change the backcolor of a command button? If yes, how?

I'm trying to use the DCount function to count the # of records on another form when the "Location" field matches the value of a field on the current form. The expression I'm using is: =DCount("[Location]","Parts","[Location] = '20' ") this works when Loaction=20 but, I would like to replace 20...