Hello all.
I have a form for entering information about sales teams performance relevant to certain dates.
As the form is, the user selects a 'team' from a combo box and then a reporting date from another combo box, then enters numerical information about their performance.
The problem is that when the user selects the same combination of team/date and enters numbers again, it creates a whole new record with new info, which causes a problem.
My idea to solve it is to use VBA to have the form retrieve the original record for editing if the user selects a combination of team/date that has already been entered.
My problem is that I don't know exactly what code to use. The wizard can create some pretty basic code for doing this with one combo box but not based on two.
Any advice would be appreciated.
I have a form for entering information about sales teams performance relevant to certain dates.
As the form is, the user selects a 'team' from a combo box and then a reporting date from another combo box, then enters numerical information about their performance.
The problem is that when the user selects the same combination of team/date and enters numbers again, it creates a whole new record with new info, which causes a problem.
My idea to solve it is to use VBA to have the form retrieve the original record for editing if the user selects a combination of team/date that has already been entered.
My problem is that I don't know exactly what code to use. The wizard can create some pretty basic code for doing this with one combo box but not based on two.
Any advice would be appreciated.
