Hi,
I'm trying to open a form in Access to show the records as filtered by a query.
I've got the following code:
Private Sub CMD_SearchMeetings_Click()
On Error GoTo myError
DoCmd.OpenForm "FRM_meetinglog", , "QRY_SearchMeetings"
Exit Sub
myError:
MsgBox Error$
Resume Next
End Sub
But it doesn't seem to want to work - it keeps asking me for parameters when I click the button even though the query runs fine on its own. I'm a novice at Access and I'm sure this is a really basic thing, but I can't seem to find anything useful on the net to help.
The query runs from the entries on the form where the button sits and when I run the query manually, it filters to the correct results. The query output is a key field in one table, which is linked to others, the form has a combination of data from various tables, but all linked back to the one key field. The reason for the multiple tables is because I have meetings which can be attended by multiple people from my organisation and others. My query checks dates, attendees from my organisation and attendees from other organisations, to link back to the individual meeting reference.
I want to be able to see all of the information for the specific meetings searched for.
Thanks,
I'm not sure that helps. My query uses input from a form, has multiple criteria that I need to be able to change and generates multiple records as the output.
Criteria include dates, meeting attendees and attendee organisations. The query I have built works. It generates a list of individual meeting references which I then want to be able to use to filter the full list of data by and display the results (along with linked data from other tables) in a form. I have the form built already, and this, with sub forms already embedded and working, can be used to scroll through all of the records. I want to be able to view a sub-set of those records, ie. meetings 1, 3, 5 and 7 were held between dates x and y with q attending, so I want to be able to scroll through those meetings seeing the full information on them.