Hi,
I have a subform with combo boxes that a user selects from and when the user gets to the last combo box a event happens to set the focus outside of the subform to a comment box which the user enters extra data. The problem is that the comment box data is not 'glued' to the data inside the subform.
If the Subform enters data into record 1 in the output table the comment box outputs its data to record 2 which is not what I want. I want the to areas linked.
Example:
- this is what I want.
ID1_____John Doe_____12/12/1952____Comment entered here
- but when the set focus comes in to the comment box I get ...
ID1_____John Doe_____12/12/1952____[blank]
ID2_____[blank] _____{blank] _____Comment entered here
ID3 ... next client ... etc.
Any suggestion on how to fix this would be appreciated
Thanks
I have a subform with combo boxes that a user selects from and when the user gets to the last combo box a event happens to set the focus outside of the subform to a comment box which the user enters extra data. The problem is that the comment box data is not 'glued' to the data inside the subform.
If the Subform enters data into record 1 in the output table the comment box outputs its data to record 2 which is not what I want. I want the to areas linked.
Example:
- this is what I want.
ID1_____John Doe_____12/12/1952____Comment entered here
- but when the set focus comes in to the comment box I get ...
ID1_____John Doe_____12/12/1952____[blank]
ID2_____[blank] _____{blank] _____Comment entered here
ID3 ... next client ... etc.
Any suggestion on how to fix this would be appreciated
Thanks