Recent content by DSimpson

This works. Thanks for your help.

Placing the requery code in the AfterUpdate event did NOT work, but using F9 does give the right results. However, I am trying to avoid an extra keystroke or click (i.e. I am trying to make the requery happen when the checkbox is clicked). I need to clarify the AfterUpdate event. It is working...

No, because the commandbox is based on a macro using the Requery command and it gave me an error when I tried to use it in the subform. I tried using the requery method in VB but it isn't giving the correct data (i.e. it doesn't update when the first checkbox is checked and when all boxes are...

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?

That is right. I have since made a change to make the location field numeric and now it is working. But, now I would like to add a second criteria that only counts the records from that location if the RETURNED field on that form is NOT checked. I am using the following expression and it is not...

I tried this and got no errors, but it didn't pull any records (i.e. the output text box in the current form always shows 0 records no matter what value is given to the text box I'm referencing in the dcount criteria statement).

It's a string and when I tried the appropriate expression I got the following error: object doesn't contain the automation object "me."

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...