troubleshooting Question

Access: Opening a Form to show records based on a Query

Avatar of Fliss Rundle
Fliss Rundle asked on
Microsoft Access
12 Comments2 Solutions122 ViewsLast Modified:

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

John Tsioumpris
IT Supervisor
Join our community to see this answer!
Unlock 2 Answers and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros