pop ups

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

If the contents of a field is blank (but the record
exists), I wish to ensure that a sub form set to pop up
is not opened when i change the contents from blank to
some character(s).

However if the original contents are not blank i wish to
have the popup open if the entry is altered(changed),
how???
 
First, a subform is a form built-into the main form. I believe you are
referring only to a pop-up form. What does this pop-up do? Is it just an
error message or does it request additional data for the change? If it is
just an error message, you may be able to use a MsgBox instead of a pop-up
form.

If the control that is being changed is a bound control, you could use the
controls OldValue property to see if the control was previously blank, if
not, then pop-up your form. This could be done in the BeforeUpdate or
AfterUpdate event of the control. The BeforeUpdate event will give you the
option to Cancel the update, if you desire.
 
Back
Top