Search results

Yes it is in the After Update event..

Both controls are on the same form. The unbound control is before the bound control. I added a msgbox but it didn't appear.

Both controls are on the same form. The message box didn't appear.

Here's the code.

I haven't written any code but the Me.bound control=Me.unbound control in the AfterUpdate of the unbound control. Unless you are referring to the vba code behind the scenes which I don't know how to get at.

Yes I'm using Access 2010.

Here is the db. The subform, frmMachineMeters, has these 23 fields. The unbound field, getBeginRollover, is the previous value that I want to go into the bound field, beginRollover, so that the table will have this value. In the AfterUpdate of the unbound field, I used...

Hi - In my form I am trying to change a bound field with the value of an unbound field that occurs before it on the form so this new value shows up in the table for that field. The unbound field contains a number from a field on the previous record from the table, and the next field, the bound...

This will be very helpful. Thanks.

The total is to be at the bottom of the subform. I will work with your suggestion. Thanks.

I tried for a week to figure this out but am stuck. If you can recall the Last Meter Count value, which was gotten using DLookup and referencing the qryMostRecentMeterUsingPK query. The shift volume is arrived at by subtracting this last meter, called lstShiftMeter from dpMeterCount. This works...

Yes. Thank you.

How is the CalcExtension: field put in the form Record Source if a table is listed there as the Record Sopurce?

Great! I tested the form and the correct previous meters are showing up for each machine. I also took some time to read up on queries so this makes sense to me now. It works great for this application. I thought a one line command was easier but I just have to learn how to create queries. I will...

I want to try using Dlookup and DMax in the Control Source for the Last Meter Reading field on the form. I set it up as follows: =DLookUp("[dpMeterCount]","tblMachineMeters","[fkMachineID]= " & [Forms]![frmMachines]![pkMachineID] And [pkMachineMeterID]=#" &...

Thanks for clearing that up. The data entry for this is done daily after each shift, which means the previous meter reading when entering the DAY shift info will be from the EVE meter of the previous date, but when entering the EVE shift info the previous shift meter reading for a particular...

I worked with this yesterday afternoon and it looks like the previous record issue that happened before is occurring, with the Last Meter Reading. When you first open the form, machine 101 info is displayed at the top, and the Last Meter Reading is correct. After filling out meter reading info...

Hi - jzwp22 - thanks again for working this. I'm a little awkward navigating through the revised form. The main form shows 1 of 26 records (26 machines) and the attached subform shows 1 of 74 records? The separate subform shows 1 of 1948 records, all the records on the main table.I clicked the...

Hi jzwp22 - Thanks again for working this. I need a little explanation of how this will work. I did go in to try it out but I don't understand what is going on behind the scenes. I clicked the new record arrow at the bottom of the form, and this cleared the form. I entered 101 in the combo box...

Great. I will look this over on Monday at work because I don't have Access on my home computer. The Begin and End Rollover counts were used by Excel to calculate volume and in creating reports. I may be able to do reporting on the meter numbers without those fields but I'm more concerned first...