How do I have my statements know which record to check on the corresponding Subform? I want them to use the data relating to the most recent entry but I don't know what kind of coding I need to use to make that happen.
How do I have my statements know which record to check on the corresponding Subform? I want them to use the data relating to the most recent entry but I don't know what kind of coding I need to use to make that happen.
When you set up Form and subForm did you do this
http://office.microsoft.com/en-us/ac...010098674.aspx
Yeah. That's all setup. I just need to what the modifier is to make my expression reference the latest data entry on a given form, is there a general command for this?
I think you are trying to get an update made on the subform to force a change on the main form. If that is your goal, the way to do that is to use the After Update function on the Subform. You can use this function on either the field level or form level in the Properties list and use VB code to instruct the updates to the main form that you need.
Take care,
Troy
This is what I am trying to do, let me give you the specific example....
I would like a text box on the main form to perform an equation between the most recent data entered in one subform and the data from another subform and then display a message in the text box depending on the outcome of the equation.
Such as...
IF subform1 mileage minus subform2 mileage is less than 250
THEN display "PM Service Due" on mainform
The trick though is that mileage is entered weekly for each vehicle in the fleet and I want the equation to ONLY reference the most recent mileage entered.
An illustrated example is attached.
Did that make any sense?