doran_doran
Registered User.
- Local time
- Today, 14:30
- Joined
- Aug 15, 2002
- Messages
- 349
Hi everyone,
Hope everyone is doing well today. (most of the coding is very much done)
1. I have a form call frmAddNewRecord.
2. Enduser click "add a new record" from swithboard to add a new record.
3. However, there are three mandatory field on the form "ga_number, PlanNum, PYE"
4. Currently, I have a code behind the form properties (before insert) to check this fields.
5. If the field left blank the system prompts user that the field was not populated and takes users back to switchboard without giving user a chance to populate any one these fields.
6. Please check my database and send me your suggestion.
7. I want system to warn end user msgbox
8. and not get out of that form , end user should be able to click on retry and fill out the missing fields (especially, all three primary fields, ga_number, plannum,pye)
Any help will be appreciated.
Dianna
Hope everyone is doing well today. (most of the coding is very much done)
1. I have a form call frmAddNewRecord.
2. Enduser click "add a new record" from swithboard to add a new record.
3. However, there are three mandatory field on the form "ga_number, PlanNum, PYE"
4. Currently, I have a code behind the form properties (before insert) to check this fields.
5. If the field left blank the system prompts user that the field was not populated and takes users back to switchboard without giving user a chance to populate any one these fields.
6. Please check my database and send me your suggestion.
7. I want system to warn end user msgbox
8. and not get out of that form , end user should be able to click on retry and fill out the missing fields (especially, all three primary fields, ga_number, plannum,pye)
Any help will be appreciated.
Dianna
