Search results

GREAT NEWS! I was able to get the code working after several tries here is the process!!! Private Sub Product_AfterUpdate() On Error GoTo Err_Product_AfterUpdate Dim 'Your Database Name' As Database Dim CDRSumCharge As Recordset ' your record Name Dim strFilter As String 'String below that is...

Any thoughts besides just undoing?

I tried out a few variants of the code that you provided with no avail. This coding will have to have an IIF statement within it for if the selected product is "Calling Charges" or "158" (which is the real productID) then search for the calling charges within CDRQ (Which is a query) and sum up...

Although that is the easy way to clear the form, I need something that is a little more functional for other staff. Their will be many more controls added to the form and It will be time consuming to undo every control. I need something a little more user friendly...One button..erase form. I...

Does anyone know of any coding that will enable me to erase a form and a sub-form at the same time while keeping let's say the Order Date and Invoice Number the same....Or...have them revert back to their defaults. Currently I have the below coding: Private Sub ClearAll_Click() Me.CustomerID =...

I am in the process of building a billing system through access and I have run into a stumbling block. I am trying to modify a lookup of product infomation with a case such as "if calling charges is selected, open CDRQ, sum all calling charges for the current date where the current open form's...