Search results

Well, I didn't put all my code, because I think my problem is the "Type Mismatch". Could you please tell me how to assign a date value to the filtercriteria? Kathrin

Thanks Wayne, but the problem persists....any other idea? Kathrin

I’m trying to get this code to work, but I’ get “Type Mismatch” on the strFilterCriteria line. C_CG_Prod is the name of my query, and Data the name of a field in the query. Dim db As Database Dim strFilterCriteria As Date strFilterCriteria = "SELECT * FROM C_CG_Prod WHERE Data = #" & InputBox...

Thanks! It seems to be working fine. Kathrin

By the way, I also tried doing the calculations on the query, but the form would only be updated after exiting and opening it, so I dlookup the value of the day before on the query and the subtract it from the day concerning the record. (to confusing?!)

Ok, I have given up on the idea of storing the calculated value, but I need it to be on the form. I have managed this by using the prerecval and also dlookup (looking up the value on the table instead of a query), problem is that if i need to go back and correct any record it wont update the...

Thanks for replying! Yes, I want to update the next record when I change a previous record. What I mean, is that it just doesn't work with new records. After updating the field TarA, the CTarA stays empty. If I go to a new record and the come back to this one it works fine... I kind of know...

Please...Can anyone help?

Hi! I have a form, which has 3 fields. One is the date, the other is the meter value (TarA), and the last is the consumption (CTarA) which is the difference between the today's meter value and yesterday's. I also want to have the option to correct previous readings if necessary, and so I have...

Thanks. I have one question, if I go back and correct TarA to D where RECID = 1, will CTarA become equal to D where RECID = 2, or does it only work for new records?

They're in the same table, and there is a single form... Thank you for replying, Kati

I'm working with a form (based on a table) that has one numeric field (CTarA) that is dependent on a different numeric field (TarA) of the previous record. When using the AfterUpdate method on field TarA, on an old record, is there a simple way of updating field CtarA of the next record? I'm at...