I'm stumped on trying to get a couple things to work in my database.
Perhaps someone could help me out.
1. I can have multiple contracts in a single project and so that's how this database will be set up. You can open the contract with the use of a command button "Open". However, I want to prevent the user from opening the F_Contract when the cboContract is blank.
I've tried I number of things but just can't get it to work.
Any ideas here?
2. I use the Edit List Form to add new contract numbers to the combo box. I'd like to have the contract number that the user just created in the edit list form, to be inputed automatically, into the cboContract once they close the edit list form.
Any ideas?
Attached is a sample database to show the issue.
Thanks for any help!
Perhaps someone could help me out.
1. I can have multiple contracts in a single project and so that's how this database will be set up. You can open the contract with the use of a command button "Open". However, I want to prevent the user from opening the F_Contract when the cboContract is blank.
I've tried I number of things but just can't get it to work.
Any ideas here?
2. I use the Edit List Form to add new contract numbers to the combo box. I'd like to have the contract number that the user just created in the edit list form, to be inputed automatically, into the cboContract once they close the edit list form.
Any ideas?
Attached is a sample database to show the issue.
Thanks for any help!