In answer to part of your question (I hope), I offer the following.

Here is some VB Script that you can use at the object level for validation.


' Entry required...
sub txtCallerName_OnBlur()
if len(frmLineDetail.txtCallerName.value) = 0 then
alert ("Caller Name is required")
frmLineDetail.txtCallerName.Focus
end if
End Sub


' Numeric validation...
sub txtQuantity_OnBlur()
if len(frmLineDetail.txtQuantity.value) > 0 then
if not IsNumeric(frmLineDetail.txtQuantity.value) then
alert ("Not a valid number")
frmLineDetail.txtQuantity.focus
end if
end if
end sub


' Date validation...
sub txtQuantity_OnBlur()
if len(frmLineDetail.txtQuantity.value) > 0 then
if not IsNumeric(frmLineDetail.txtQuantity.value) then
alert ("Not a valid number")
frmLineDetail.txtQuantity.focus
end if
end if
end sub