I have two issues here :
(1) Minor Issue
I have two forms linked to each other , that is a parent form and a sub form , now I wanted the dates for both forms to be always the same . Therefore , to implement that business rule , I have come up with a VBA code below:
Private Sub TTDate_BeforeUpdate(Cancel As interger)
If Me.TTDate <> Me.parent!Paydate Then
MsgBox " Please ensure that the date on the form above is entered here" , VbOnly, " Wrong Entry"
Cancel = True
The above code works but it does not give a signal beep warning! Any Idea here?
(2) Major Issue
I have some controls on both forms that need to have data or are mandatory when doing data capturing , now I'm using the built in forms validations and a message ( " Please note this control cant be blank"), well fair enough when the control is not filled the massage ( " Please note this control cant be blank") pops up , but when you say Okay there is also another Access Standard message that pops up almost stating the same thing , this what I do not want , I just want my standard message only nothing else , how do I suppress this Access message.
I'm also think of doing away with the built in validation by replacing with mine as follows:
Dim Cancel As Interger
If me.TTDate = " " Then
MsgBox " Please note this control cant be left blank", VBOnly, " Missing Data"
Cancel = True
If this okay with you , then where do I put it or which event property is appropriate for this? Or does it mean that I have paste per each control?