If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Message Box
Hi,
I have a form that when I click on the close button would like for it to check the data in the Subform and make sure that the Date fields are not null, if it is I would like a message box to pop up and say "Please fill in the date", I am not sure if its possible to do it with a subform. I tried it but keep getting an error. Thanks in advance for anyone who can help. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200805/1 |
#2
|
|||
|
|||
Conditional Message Box
Hi Sharon,
do these dates need to be filled before a record is saved? Warm Regards, Crystal Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day * Sharon123 via AccessMonster.com wrote: Hi, I have a form that when I click on the close button would like for it to check the data in the Subform and make sure that the Date fields are not null, if it is I would like a message box to pop up and say "Please fill in the date", I am not sure if its possible to do it with a subform. I tried it but keep getting an error. Thanks in advance for anyone who can help. |
#3
|
|||
|
|||
Conditional Message Box
if so then in the table specify required as YES
"strive4peace" wrote in message ... Hi Sharon, do these dates need to be filled before a record is saved? Warm Regards, Crystal Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day * Sharon123 via AccessMonster.com wrote: Hi, I have a form that when I click on the close button would like for it to check the data in the Subform and make sure that the Date fields are not null, if it is I would like a message box to pop up and say "Please fill in the date", I am not sure if its possible to do it with a subform. I tried it but keep getting an error. Thanks in advance for anyone who can help. |
#4
|
|||
|
|||
Conditional Message Box
actually, I was going to suggest a form BeforeUpdate event if the dates
are required... then the changes to the record can be CANCELled if the user chooses to dump the changes (either the new record or edits to an existing record) Warm Regards, Crystal Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day * Jason wrote: if so then in the table specify required as YES "strive4peace" wrote in message ... Hi Sharon, do these dates need to be filled before a record is saved? Warm Regards, Crystal Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day * Sharon123 via AccessMonster.com wrote: Hi, I have a form that when I click on the close button would like for it to check the data in the Subform and make sure that the Date fields are not null, if it is I would like a message box to pop up and say "Please fill in the date", I am not sure if its possible to do it with a subform. I tried it but keep getting an error. Thanks in advance for anyone who can help. |
Thread Tools | |
Display Modes | |
|
|