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"
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.