RE: Launch Pop Up on Null Value in field

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 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: Problem with webbrowser control
    ... "Paul G. Tobey " <p space tobey no spam AT no instrument no spam DOT ... etc. method calls that IESample makes. ... What confuses me a bit is, that the _same_ html page throws exceptions in control, but loads fine in iesample/iesimple. ... If I call it via local html file in webbrowser control, drm server will refuse me ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: SD CA
    ... Paul wouldn't know. ... subdue and control the population. ... Depends on what you call success, ... turning the government over to the hands of the likes of Murdoch and other ...
    (alt.smokers.cigars)
  • Re: SD CA
    ... Paul wouldn't know. ... subdue and control the population. ... Depends on what you call success, ... Your fascist inclinations are insane. ...
    (alt.smokers.cigars)
Loading