Hi,
Im not too sure about the best way to update/refresh values in a field based on a lookup from a combo box. Hopefully I can explain myself clearly enough for someone to be able to help me.
I have a form called FrmPlanningPositions that looks after space requirements for various positionstypes.
It includes PositionName, Staff Numbers and AreaAllowed.
In another form WorkStyleDef I allow people to define workstyle types which includes a field for type (A,B etc) and size (6sqm, 9sqm).
In FrmPlanningPositions I have a combo box called WorkstyleDefID which runs a query which looks up the workstyles types and sizes defined for this project based on the project.id in WorkStyleDef.
On the AfterUpdate event of the WorkstyleDefID field in the FrmPlanningPositions form I have this code to automatically populate the area allowed field based on the workstyle type selected.
[AreaAllowed] = [WorkstyleDefID].[Column](2)
[OccupantWorkstyle] = [WorkstyleDefID].[Column](1)
My problem is that if there is a change made to the size in FrmWorkStyleDef this change isn't automatically reflected in the AreaAllowed field in FrmPlanningPositions.
What's the best way to update or refresh this?
Thanks for your help. Please let me know if you need more info.
Im not too sure about the best way to update/refresh values in a field based on a lookup from a combo box. Hopefully I can explain myself clearly enough for someone to be able to help me.
I have a form called FrmPlanningPositions that looks after space requirements for various positionstypes.
It includes PositionName, Staff Numbers and AreaAllowed.
In another form WorkStyleDef I allow people to define workstyle types which includes a field for type (A,B etc) and size (6sqm, 9sqm).
In FrmPlanningPositions I have a combo box called WorkstyleDefID which runs a query which looks up the workstyles types and sizes defined for this project based on the project.id in WorkStyleDef.
On the AfterUpdate event of the WorkstyleDefID field in the FrmPlanningPositions form I have this code to automatically populate the area allowed field based on the workstyle type selected.
[AreaAllowed] = [WorkstyleDefID].[Column](2)
[OccupantWorkstyle] = [WorkstyleDefID].[Column](1)
My problem is that if there is a change made to the size in FrmWorkStyleDef this change isn't automatically reflected in the AreaAllowed field in FrmPlanningPositions.
What's the best way to update or refresh this?
Thanks for your help. Please let me know if you need more info.
