Hi guys, I've been trying to create a macro so that when i click on the 'search' button, it will get the data from the space for you the type. However, I keep getting this error: "Compile Error: Method or Data Member not found"
I'm trying to run QueryDisplay form to get the data keyed in and run a query. Can anyone help me out? Thanks alot
Option Compare Database
Option Explicit
Private Sub cmdSearch_Click()
Me.QueryDisplay.Requery
End Sub
Private Sub cmdReset_Click()
Me!txtArtiste = Null
Me!txtGender = Null
Me!txtSong = Null
Me!txtGenre = Null
Me!noMin = Null
Me!noMax = Null
Me!txtRecordLabel = Null
Me.txtAlbum = Null
Me!QueryDisplay.Requery
End Sub
Private Sub cmdViewQuery_Click()
DoCmd.OpenQuery "Query"
End Sub
Private Sub cmdPreviewReport_Click()
DoCmd.OpenForm "QueryDisplay", acViewPreview
End Sub
Private Sub cmdSearch_DblClick(Cancel As Integer)
End Sub
Private Sub Form_Load()
End Sub
I'm trying to run QueryDisplay form to get the data keyed in and run a query. Can anyone help me out? Thanks alot
Option Compare Database
Option Explicit
Private Sub cmdSearch_Click()
Me.QueryDisplay.Requery
End Sub
Private Sub cmdReset_Click()
Me!txtArtiste = Null
Me!txtGender = Null
Me!txtSong = Null
Me!txtGenre = Null
Me!noMin = Null
Me!noMax = Null
Me!txtRecordLabel = Null
Me.txtAlbum = Null
Me!QueryDisplay.Requery
End Sub
Private Sub cmdViewQuery_Click()
DoCmd.OpenQuery "Query"
End Sub
Private Sub cmdPreviewReport_Click()
DoCmd.OpenForm "QueryDisplay", acViewPreview
End Sub
Private Sub cmdSearch_DblClick(Cancel As Integer)
End Sub
Private Sub Form_Load()
End Sub