RE: Launch Pop Up on Null Value in field

Wayne,

No problems there, so I'm not sure what's going on either...obviously
something on my end.

The purpose of this was to remind users to update these fields because they
were new fields added when we switched to a new database and design. However,
I realized that I had default populated 2 of these fields and to be sure, I
ran a couple quick queries to validate that the only one of these 3 fields
that could be and was null was the Category field. Therefore, I simply
included the check only on that field and everything will work fine that way.

Thanks very much for your help!

"Wayne-I-M" wrote:

Well I am lost then. It works for me but not for you. We must be doing
something different.

try each of these in turn and make sure they all work

If IsNull(Me.Priority) Then

If IsNull(Me.Category) Then

If IsNull(Me.Condition) Then

--
Wayne
Manchester, England.



"Paul" wrote:

Yep, checked those and I'm all set there - no problems.

"Wayne-I-M" wrote:

Oh and have you checked the field names and the control names ??

The field name is the names of the field in the table
The control name is the name of the control on the form that is linked
(sourced) to the table field.

Is the "Control names" that are used in the code.

Open the properties box and check the names in the "other" column.


--
Wayne
Manchester, England.



"Paul" wrote:

Wayne, this is partly working.

If I write it as you have shown, I get an error:
Runtime Error '13': Type Mismatch

If I go into Debug, the line below is highlighted:
If IsNull(Me.Priority Or Me.Condition Or Me.Category) Then

However, if I limit it to checking just one of the fields, i.e.,
Me.Priority, it works fine.

I think it may have to do with how to handle it if there IS in fact a value
populated in the field so it is NOT Null.

Do you agree? So if the value is NOT Null, then how should I bypass it and
keep going?

Thanks!

"Wayne-I-M" wrote:

Or use this

Private Sub Form_Open(Cancel As Integer)
If IsNull(Me.Priority Or Me.Condition Or Me.Category) Then
DoCmd.OpenForm "Reminder", acNormal, "", "", , acNormal
End If
End Sub

Think this looks a little cleaner

--
Wayne
Manchester, England.



"Paul" wrote:

I want to launch a pop up form I created called 'Reminder' whenever a record
is opened on my Projects form and one or more of 3 fields is null.

The fields are:
Priority
Condition
Category

Having a bit of trouble, so any help would be appreciated. Thanks!
.

Relevant Pages

  • RE: Launch Pop Up on Null Value in field
    ... "Paul" wrote: ... The control name is the name of the control on the form that is linked ... Runtime Error '13': Type Mismatch ... is opened on my Projects form and one or more of 3 fields is null. ...
    (microsoft.public.access.forms)
  • RE: Launch Pop Up on Null Value in field
    ... "Paul" wrote: ... The data populating them is text, and it is querying the options available ... Runtime Error '13': Type Mismatch ... is opened on my Projects form and one or more of 3 fields is null. ...
    (microsoft.public.access.forms)
  • RE: Launch Pop Up on Null Value in field
    ... "Paul" wrote: ... The control name is the name of the control on the form that is linked ... Runtime Error '13': Type Mismatch ... is opened on my Projects form and one or more of 3 fields is null. ...
    (microsoft.public.access.forms)
  • RE: Launch Pop Up on Null Value in field
    ... The control name is the name of the control on the form that is linked ... "Paul" wrote: ... Runtime Error '13': Type Mismatch ... is opened on my Projects form and one or more of 3 fields is null. ...
    (microsoft.public.access.forms)
  • RE: Launch Pop Up on Null Value in field
    ... The control name is the name of the control on the form that is linked ... "Paul" wrote: ... Runtime Error '13': Type Mismatch ... is opened on my Projects form and one or more of 3 fields is null. ...
    (microsoft.public.access.forms)