how to run a delete query

  • Thread starter Thread starter Gina
  • Start date Start date
G

Gina

Hi

when I call the query in vba the required value for the condition is there
but still a box for parameter input comes up typing in the value by hand
works
(at least)

here's my code
____
If Not IsNull(Me.txtDateOld) And Not IsNull(Me.txtReNROLD) _
And Not IsNull(Me.txtWorkID) Then
DoCmd.OpenQuery "qry_Invoice_Del"
Form_frmInvoice.Requery
Form_frmInvoice.Refresh

Me.Requery
Me.Refresh
End If
____

I don't know where the problem could be struggeling around this silly thing
qiute some time now ... and still it doesn't make sense
am I calling it correctly at all ???
Gina
 
Back
Top