No results?

[MartijnAn]

Hi All,

I made a form with a specific field. If I enter a value into this field it automatically runs a query. The results are shown in another form. However if I return to the previous form and enter the same (or another) value it still runs the query but this time with no results? I think it is a memory problem. The previous form is closing.

Does anyone have the answer to this one?

Thanks

 

[john471]

How are you "automatically" running the query? Are you using VBA code or a macro ?

Can you post the details, and alos the SQL of the query. This may help someone to help you.

 

[MartijnAn]

I am using the openargs statement for the form that will be opened

code on form1:

Private Sub Knop7_Click()
If Tekst1 = True Then
DoCmd.OpenForm "formulier3", , , , , , Me.Name
DoCmd.Close acForm, "formulier1"
End If
Set RdoRange = Nothing
End Sub

code on form2:

Private Sub Form_open(Cancel As Integer)
Select Case Me.OpenArgs
Case Is = "formulier1"
Me.RecordSource = "Qrformulier1"
Knop46.Visible = False
Case Is = "formulier2"
Me.RecordSource = "Qrformulier2"
Knop46.Visible = True
End Select
Set RdoRange = Nothing
End Sub