I've posted this in 'Modules & VBA' as essentially I think the solution is in the VBA code..
I have the very beginnings of a compensation claims database. Please see the attached.
I want to be able to :
Go to Form A, and click on the right-arrow buttons at the right-hand side. On clicking, I'd like the claim step ID on Form A to change from 'S1 S3' to 'S1 S4' and then for the step meaning field alongside to update accordingly. Form A should stay open in the background, while the 'frmNextStep_S1 S3 to S1 S4' Form opens and the step ID updates (to 'S1 S4') on THAT Form too (signifying a move one step down the claims processing pipeline). And I'd like the change-over to S1 S4 to be recorded in the underlying Table.
I'd be very grateful for guidance on this. I've tried various things in the VBA code behind the right-arrow button (I guess that's where the solution lies?), but haven't been able to achieve the desired result.
Thank you
I have the very beginnings of a compensation claims database. Please see the attached.
I want to be able to :
Go to Form A, and click on the right-arrow buttons at the right-hand side. On clicking, I'd like the claim step ID on Form A to change from 'S1 S3' to 'S1 S4' and then for the step meaning field alongside to update accordingly. Form A should stay open in the background, while the 'frmNextStep_S1 S3 to S1 S4' Form opens and the step ID updates (to 'S1 S4') on THAT Form too (signifying a move one step down the claims processing pipeline). And I'd like the change-over to S1 S4 to be recorded in the underlying Table.
I'd be very grateful for guidance on this. I've tried various things in the VBA code behind the right-arrow button (I guess that's where the solution lies?), but haven't been able to achieve the desired result.
Thank you