I have sample DB for you to look at.
When a project is added, I want to add a TEMP contract number which I have done via, the "Add TEMP Contract Num" button.
It puts the temp number in the SF_Contract, cboContract.
What I need help with is two things:
1. Once I press the "Add TEMP Contract Num" button, I want the cboContract to not be dirty. I've tried a few things but keep getting errors.
2. If I press the button multiple times, it changes the same record in the SF_Contract. I want it to go to a new record and place a new temp contract number in it.
Can you guys help me out?
Thanks.
When a project is added, I want to add a TEMP contract number which I have done via, the "Add TEMP Contract Num" button.
It puts the temp number in the SF_Contract, cboContract.
What I need help with is two things:
1. Once I press the "Add TEMP Contract Num" button, I want the cboContract to not be dirty. I've tried a few things but keep getting errors.
2. If I press the button multiple times, it changes the same record in the SF_Contract. I want it to go to a new record and place a new temp contract number in it.
Can you guys help me out?
Thanks.