Hi.....
I am an enthusiastic ACCESS amateur and new to the Tek-Tips fora. I am developing a work related hazard/risk assessment tool, where I have currently hit a 'knowledge gap'
I’m convinced I have set everything up correctly, but I lack the VBA programming skills to get the following to happen:
1: I’ve created an unlinked ‘stand alone’ stock table of hazards which can be seen from a pop up form FrmHazards (when you press the new hazard button on the subform FrmNewHazard);
2: I want to sequentially populate the (continuous) subform called FrmNewHazard with an hazard of my choice on a one by one basis from the choices contained in the stand alone form above (I’ve currently got my method of choosing the hazard set up as a combo box);
I seem to be missing the instruction to tell the underlying query to add the new hazard I pick to the form FrmNewHazard??
I don't know if this is the correct protocol (please correct me if not), but the genesis of my DB can be found on my public space
Hope someone can put me on the right trail? Thanks anyway.
I am an enthusiastic ACCESS amateur and new to the Tek-Tips fora. I am developing a work related hazard/risk assessment tool, where I have currently hit a 'knowledge gap'
I’m convinced I have set everything up correctly, but I lack the VBA programming skills to get the following to happen:
1: I’ve created an unlinked ‘stand alone’ stock table of hazards which can be seen from a pop up form FrmHazards (when you press the new hazard button on the subform FrmNewHazard);
2: I want to sequentially populate the (continuous) subform called FrmNewHazard with an hazard of my choice on a one by one basis from the choices contained in the stand alone form above (I’ve currently got my method of choosing the hazard set up as a combo box);
I seem to be missing the instruction to tell the underlying query to add the new hazard I pick to the form FrmNewHazard??
I don't know if this is the correct protocol (please correct me if not), but the genesis of my DB can be found on my public space
Hope someone can put me on the right trail? Thanks anyway.