Null coding

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

Rpettis31

I have a form that will create a new form if one has not been created or go
to the existing form if one has been created, this code used to work now it
does not.

I am not sure what is wrong with this code
If IsNull(Me.txtRWNId) Then Call Create_RWForm Else Goto_RWForm

In all cases now a new form is created even with a value in the txt box?
 
sometimes you have to double check. Try this one:

If IsNull(Me.txtRWNId) or me.txtRWNId="" Then Call Create_RWForm Else
Goto_RWForm


hth
 
Apparently it actually is with this line which is the method I was calling
and it keeps adding a form.
DoCmd.OpenForm "frmRWForm", acNormal, , "[RWNumber]=" & Me.txtRWNId

I added the data mode edit and it pulls the item up. However I have this
exact code for another button to call a different form and there is not any
issues with it.

This code worked for three weeks so I am not sure why it decided not to work
now?
Any ideas?
 
Back
Top