I'm using the code Forms!frmMainBooking!frmBooking.Form!intCourseDetails = [intCourseDetails] to copy an integer from one subform to another. It works fine but I'm not sure how to initiate it.
I've got 3 subforms, in 1 the user selects a course from a drop down box, this loads another form listing all dates for that particular course, user finds correct course, double clicks it and then the subform moves to the correct record. This si the moment when I want the code above to be initiated but just can't get it to work. Have tried After Update for the field On Change and After Update and On Data Change for the subform itself but non of them run the command (I have tried using On Click just to confirm that it works). Anyone know how I can initiate the command?
I've got 3 subforms, in 1 the user selects a course from a drop down box, this loads another form listing all dates for that particular course, user finds correct course, double clicks it and then the subform moves to the correct record. This si the moment when I want the code above to be initiated but just can't get it to work. Have tried After Update for the field On Change and After Update and On Data Change for the subform itself but non of them run the command (I have tried using On Click just to confirm that it works). Anyone know how I can initiate the command?
